Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have a source table as attached (Tab- RAW_Data).
https://drive.google.com/open?id=1-D-PzY3u2M5hWhMTp7Oeo1URDpJA_st1
I have created a Matrix Table which gives me the %CT Count over
I want to create a measure which will calculate the MoM%Change based on the %CT Count as demonstrated in the "Desired Tab" as following. Is it possible to create such a measure in DAX?
Thank you in advance
Solved! Go to Solution.
Hi smpa01,
To achieve your requirement, you should create an index firstly. Click Query Editor-> Add Column->Index Column. After close&applied, create a calculate column using DAX below:
Change = VAR previous_month = CALCULATE(MAX(Desired[Month]), FILTER(Desired, Desired[Index] = EARLIER(Desired[Index]) - 1)) VAR current_month = Desired[Month] VAR previous_month_Count = CALCULATE(MAX(Desired[%CT Count of REC to PMT Ageing]), FILTER(Desired, Desired[Index] = EARLIER(Desired[Index]) - 1)) VAR current_month_count = Desired[%CT Count of REC to PMT Ageing] RETURN IF(current_month <> "July", (current_month_count - previous_month_Count) / previous_month_Count, BLANK())
Regards,
Jimmy Tao
Hi smpa01,
To achieve your requirement, you should create an index firstly. Click Query Editor-> Add Column->Index Column. After close&applied, create a calculate column using DAX below:
Change = VAR previous_month = CALCULATE(MAX(Desired[Month]), FILTER(Desired, Desired[Index] = EARLIER(Desired[Index]) - 1)) VAR current_month = Desired[Month] VAR previous_month_Count = CALCULATE(MAX(Desired[%CT Count of REC to PMT Ageing]), FILTER(Desired, Desired[Index] = EARLIER(Desired[Index]) - 1)) VAR current_month_count = Desired[%CT Count of REC to PMT Ageing] RETURN IF(current_month <> "July", (current_month_count - previous_month_Count) / previous_month_Count, BLANK())
Regards,
Jimmy Tao
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |