Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
We have snapshot Amount in our Data Model.
So, I have to create a calendar which automatically takes the last date amount of month/year if I have to calculateas below:
If(Calendar(Month) = Jan, Sum(Amount)) = (Result should be as 3000 )
&
If(Calendar(Year) = 2017, Sum(Amount)) = (Result should be as 5000)
Regards,
R_
HI @R_
Can you please post a sample of what you expect your output to look like?
eg, do you just want 2 rows for your example data or still have 8 rows?
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 |
---|---|
109 | |
102 | |
84 | |
79 | |
68 |
User | Count |
---|---|
120 | |
110 | |
94 | |
81 | |
77 |