Forum Discussion

Arjun_reddy's avatar
Arjun_reddy
Helper I
3 years ago
Solved

dax query

Hi Community team,   need you help on one of the dax query, please find the below snap and understand my rrequirement, write a dax query on that, I have year, period, sales fields, want to find ou...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    Whenever you have the opportunity to, share the download link of the PBI file with a Calendar Table and a Period column in the Calendar Table.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

There are 5 periods in the max year (not 6).  Also, since P3 is not avaiable in the max year, why should that be considered for the previous year?  Please revise your question and clearly show how you got 19% as the result.  Share data in a format that can be pasted in an MS Excel file.