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.
https://drive.google.com/file/d/1W9M2bYEZyrreuUsSpVU9D3I1tr1ogIk3/view?usp=sharing
Im trying to get the cumulative of Funding, But not able to, can anyone help? Expected result is shown, also when drilled up to yearly level it should work fine.
Expected:
Thanks in advance
@Antmkjr , if you do not have a date column, Create one like
date = "01 " & [Month Name] & " " & [year] // change data type to date
Then try a measure like
Cumm Sales = CALCULATE(SUM(Table[Funding]),filter(allselected(Funding),Funding[Date] <=max(Funding[Date])))
Ideally that should work, I have tried this
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |