Calculation on cost based on specific date

[Sona2023]

Hi , 

I need to calculate the actual cost data to specific date. 

In relation to this existing report – how to create a measure to specify actual cost data to a specific date will display as it does and after a specific date x-1 so that the value is reversed?

[djurecicK2 · Accepted solution]

Hi @Sona2023 ,

 Assuming you have a date table, you can do something like this:

Please adjust for your table and field names

Cost up to date= CALCULATE([Cost Measure],FILTER(ALL(Datetable),Datetable[Date]<="12/2/2022"))

Cost after date= CALCULATE([Cost Measure],FILTER(ALL(Datetable),Datetable[Date] >"12/2/2022"))

Please accept as solution if this answers the question- thanks!