Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi I want to create a measure to calculate the cumulative sum for specific year in this case its 2023, it starts the calculation from Jan 2023 and correctly sums till Dec 2023 but continues with the same sum beyond Dec 2023. I dont want it to show any calculation for 2024 in this measure.. it should end at Dec 2023 and blank beyond it. Since I will be comparing this in seoarate columns in a visual table and bar charts. Attached is formula and table
.
Hi @adni85 ,
Thanks @vicky_ for the quick reply. I have some other thoughts to add:
You can create a new measure.
Measure = IF(YEAR(MAX('Table'[Date]))=2023,[Expected Net Loss Total (2023)],BLANK())
Then the result is as follows.
If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
What if I want to calculate for CY2021 or CY2020?
You can try adapt the solution here: https://www.sqlbi.com/articles/previous-year-up-to-a-certain-date/
User | Count |
---|---|
83 | |
69 | |
68 | |
65 | |
54 |
User | Count |
---|---|
93 | |
93 | |
91 | |
76 | |
69 |