Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello,
I am struggling to get total of measure.
I created 2 measures as below:
DEC New = CALCULATE(SUM(V_Cust_Aging[Total Over 1 Year]), DATEADD(DimDate[Date],-1,MONTH)),
JAN New = CALCULATE(SUM(V_Cust_Aging[Total Over 1 Year]), DATEADD(DimDate[Date],0,MONTH))
Third measure to compare above 2 measures as below
JAN Cal = IF( [JAN New]=0, BLANK() ,min([DEC New],[JAN New]))
but the total is not correct ignoring
Please help me to write JAN Cal measure so that total come correct
Regards
Samar
Solved! Go to Solution.
@Anonymous , based on what you using in visual (group by visual)
sumx(values(DimDate[Month]),IF( [JAN New]=0, BLANK() ,min([DEC New],[JAN New])))
Use any other group by in place of DimDate[Month]
@Anonymous , based on what you using in visual (group by visual)
sumx(values(DimDate[Month]),IF( [JAN New]=0, BLANK() ,min([DEC New],[JAN New])))
Use any other group by in place of DimDate[Month]
Thanks a lot! Amit,
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |