Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Team,
Good Morning and hope doing good.
I have a issue with Previous Quarter Calculation and details are below.
Please note that i dont have any date column in my model and sample data looks like below table.
Hi @Anonymous ,
I think you need to use all function to replace allselected function.
When you apply slicer/filter on your table, allselected function will enable these filter effect to your formula, power bi can't find out correspond record in filtered table records.
Prev Quarter Sales = VAR currRank = MAX ( Sales_Table[Fiscal Quarter Rank] ) RETURN CALCULATE ( SUM ( Sales_Table[Sales Amt] ), FILTER ( ALL ( Sales_Table ), Sales_Table[Fiscal Quarter Rank] = currRank - 1 ) )
Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT
Regards,
Xiaoxin Sheng
HI @Anonymous ,
Can you please explain more detail about your scenario? If my formula not help, please share a pbix file for test.
Regards,
Xiaoxin Sheng
Sure, i am trying to upload PBIX but not finding the option to upload?
Coud you please anyone share me the steps to upload an PBIX file.
Hi @Anonymous ,
You can upload to onedrive or google drive, then share link here.
Notice: do mask on sensitive data before share.
Regards,
Xiaoxin Sheng
Hi Team,
Any Update Please.......
User | Count |
---|---|
98 | |
91 | |
84 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |