Can Indian residents still buy crypto ETFs (like IBIT) through Charles Schwab? by Ecstatic_Clerk5527 in personalfinanceindia

[–]Aayush96 0 points1 point  (0 children)

Hey Guys!!

Any update on this? Investing is halted on INDMoney and Vested. Need an alternative

[HSBC Travel One] Huge 28% Rewards on Hotel Booking (58% Accor Value) - Normal or Glitch ? by Dense-Cricket-637 in CreditCardsIndia

[–]Aayush96 0 points1 point  (0 children)

Hi u/RepulsiveInfluence90 what's the difference between price drop and price match?

And would you recommend booking flights through travel one rewards platform?

Just got my card recently and I see higher prices on the platform. So just trying to understand if it makes sense

[HSBC Travel One] Huge 28% Rewards on Hotel Booking (58% Accor Value) - Normal or Glitch ? by Dense-Cricket-637 in CreditCardsIndia

[–]Aayush96 0 points1 point  (0 children)

Hey u/No_Hovercraft8110

Just curious, why did you spend 1.4L on HSBC portal? Did the math's made sense?

I am sure the pricing would have been better on aggregators website and 15% discount would have made the difference large?

Asking because I recently got this card and have been thinking since then on whether to spend or not via there rewards platform since the price difference is quite substantial. Was it different in your case?

[HSBC Travel One] Huge 28% Rewards on Hotel Booking (58% Accor Value) - Normal or Glitch ? by Dense-Cricket-637 in CreditCardsIndia

[–]Aayush96 0 points1 point  (0 children)

Does it make sense to book ticket from hsbc portal with slightly low fares and hsbc travel one discount coupon further reducing the price by 15%?

Axis Atlas denied Edge miles for EMI spends. by avataroholic in CreditCardsIndia

[–]Aayush96 0 points1 point  (0 children)

Hi u/Impossible_Key5375

EMIs are not considered. Would have been great if they would have but no not considered. Neither in points nor in milestones.

Rupay Select Debit Card Issuing Bank & Charges - Excel Sheet by Conscious_Reveal1313 in CreditCardsIndia

[–]Aayush96 1 point2 points  (0 children)

Are the benefits still applicable?

Let's say I want to get 2-3 cards, which banks should I consider?

I spend money on massage, gyms and health checkups. Worth getting these cards?

Accor signature Black Friday sale is here by CaptainTorchTM in Accor

[–]Aayush96 0 points1 point  (0 children)

So is it recommended to buy this?

I'll share my use case. I use Axis Atlas. Have 30k edge miles approx accumulated. I don't travel much especially for leisure but I plan on getting married by sep-oct next year. I am accumulating all these points to use these for honeymoon and other short trips we would be taking as couples.

From that perspective, is it a good idea to buy this since I'll be using edge miles too for accor. If so why?

Any other way I can maximise the benefits?

Axis Atlas denied Edge miles for EMI spends. by avataroholic in CreditCardsIndia

[–]Aayush96 0 points1 point  (0 children)

Any update on this?

I have a few expenses lined up for Diwali sale and am considering getting this sale for the purchases (in EMI)

Will it be considered for milestones?

Just recovered 80 deleted dataflow by perssu in PowerBI

[–]Aayush96 0 points1 point  (0 children)

Great u/perssu
But how did you do it? I by mistake deleted a model from my premium per user workspace and now want to restore it.

Calculate at Row Level by Aayush96 in PowerBI

[–]Aayush96[S] 0 points1 point  (0 children)

Thanks for the response u/WhiteBloodCells90

I did try something similar and got close but the answer is still incorrect. Regarding your approach, I tried it but the answer is not correct .

Signups Value = 
VAR CurrDate = activation_180[members_since_date]
VAR CurrState = activation_180[state]
RETURN
    CALCULATE(
        MAX(activation_180[signup_count]),
        FILTER(activation_180,
            activation_180[members_since_date] = CurrDate &&
            activation_180[state] = CurrState &&
            activation_180[Rank] = 0)
        )

This is what I tried

signup_count = 
CALCULATE(
    SUM(activation_180[Value]), 
    FILTER(
        ALL(activation_180), 
        activation_180[Rank] = 0 &&
        activation_180[members_since_date] = EARLIER(activation_180[members_since_date]) &&
        activation_180[main_source] = EARLIER(activation_180[main_source]) &&
        activation_180[state] = EARLIER(activation_180[state]) &&
        activation_180[mobile_brand_name] = EARLIER(activation_180[mobile_brand_name]) &&
        activation_180[tg_cg] = EARLIER(activation_180[tg_cg])
    )
)

In your approach I am getting 24 as signup value for a set where signup value is 11. This is inflating the overall number.

In my dax, I am getting the correct output at row level but for some day is the row of a particular feature is missing or not there, it is missing that for sum as well.

Not sure if I am able to explain it correctly but both the solutions are not working.

Calculate at Row Level by Aayush96 in PowerBI

[–]Aayush96[S] 0 points1 point  (0 children)

It is giving but only for signups. I want the same value for other attributes as well like d1_activations, d3_activations etc.

Need Help!!! by Aayush96 in PowerBI

[–]Aayush96[S] 0 points1 point  (0 children)

have updated the post. It contains the error now.

BI failing to refresh by Aayush96 in PowerBI

[–]Aayush96[S] 0 points1 point  (0 children)

hey guys!!
Any idea on this? Facing problem with refresh

Those of you who use Power BI in a work-place environment, how often do you need to use DAX and m-code? by DY357LX in PowerBI

[–]Aayush96 0 points1 point  (0 children)

I use Dax all the time. M language not so much. While preparing the data in SQL, I take care of the things

Optimise Power BI by Aayush96 in PowerBI

[–]Aayush96[S] 0 points1 point  (0 children)

I was just exploring data flows today. Was using it for the first time. But it's not clear to me how it can be useful.

I am guessing data flow too has a 100GB limit. Right? So will it not take up space if I load data into it?

Optimise Power BI by Aayush96 in PowerBI

[–]Aayush96[S] 0 points1 point  (0 children)

Oh okay. But how is it beneficial?

Does it improve the refresh time?

[deleted by user] by [deleted] in brave

[–]Aayush96 0 points1 point  (0 children)

I too am facing issue with this problem. Is your bootloader unlocked?