Forum Discussion

femcoldt's avatar
femcoldt
Frequent Visitor
2 years ago

Need help with DAX

Hi everyone,  I am in a situation. the screen shot below is in excel, i have all the measures except for the ones in the red rectange. I am fighiting to get a way to calcualte this in powerbi.  ...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

Hi,

PBI file attached.  All the growth rates appear in 1 row itself (YoY).

Hope this helps.

 

femcoldt's avatar
femcoldt
Frequent Visitor
2 years ago

Hi Ashish_Mathur , thanks so much for your help. This is well appreciated.

 

I still cant fid the values for the YTD/YTG from the results or am i looking at the figures wrongly

Thanks

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    2 years ago

    Share the download link of the MS Excel file again.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    2 years ago

    Hi,

    Why is the YTD/YTG calculation from Jan-Aug/Sep-Dec?

  • femcoldt's avatar
    femcoldt
    Frequent Visitor
    2 years ago

    Hi Ashish_Mathur it is a business metric that the business uses. I dont know why they do that

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    2 years ago

    Hi,

    Unless i know the logic of the month selection, i cannot help.