Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Measure - rolling one day not include first day

Hi, Trying to create a rolling 1 day cost to show difference in cost from yesterday, but my measure is including the first day;  Cost minus previous day = SUM('UsageDetails'[Cost]) - [previous day]...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

I couldnt get the suggested measure to work the output was eg 9159.49 instead of 0.03. I have instead probably not done it the best way 

blank day = if (SUM(UsageDetails[Cost]) = [Cost minus previous day], 0 , SUM('UsageDetails'[Cost]) - [previous day]) the only issue with this is if the dates dont run in order, I shall create a separate calendar table.