undefined

[adni85]

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

 

 

.

[Anonymous · Accepted solution]

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. 

[adni85]

What if I want to calculate for CY2021 or CY2020?

[vicky_]

You can try adapt the solution here: https://www.sqlbi.com/articles/previous-year-up-to-a-certain-date/