Forum Discussion
undefined
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.
3 Replies
You can try adapt the solution here: https://www.sqlbi.com/articles/previous-year-up-to-a-certain-date/
What if I want to calculate for CY2021 or CY2020?
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.
