Forum Discussion
Accumulated vs Daily
Hi,
I'm trying to create a table where I have a column with values accumulated by product since the beginning of the month and need the value of only the day in a new column. I do not know if a new column or a measurement which is the right/efficient one. What i want to do is a slicer that user chooses to see the values accumulated or daily.
I think the function to use is EARLIER, but I do not know how.
Can you help me?
Thanks
Hi Fred_PT,
You can create a calculated column like below:
Value daily = var pre= CALCULATE(MAX(Table1[Value accum]), FILTER('Table1','Table1'[Product]=EARLIER(Table1[Product]) && 'Table1'[Date]<EARLIER('Table1'[Date])))
return 'Table1'[Value accum]-preOr create a measure:
Measure = var p=CALCULATE(MAX('Table1'[Value accum]),FILTER(ALL('Table1'),'Table1'[Product]=MAX('Table1'[Product]) && 'Table1'[Date]<MAX('Table1'[Date])))
return MAX(Table1[Value accum])-pBest Regards,
Qiuyun Yu
2 Replies
Hi Fred_PT,
You can create a calculated column like below:
Value daily = var pre= CALCULATE(MAX(Table1[Value accum]), FILTER('Table1','Table1'[Product]=EARLIER(Table1[Product]) && 'Table1'[Date]<EARLIER('Table1'[Date])))
return 'Table1'[Value accum]-preOr create a measure:
Measure = var p=CALCULATE(MAX('Table1'[Value accum]),FILTER(ALL('Table1'),'Table1'[Product]=MAX('Table1'[Product]) && 'Table1'[Date]<MAX('Table1'[Date])))
return MAX(Table1[Value accum])-pBest Regards,
Qiuyun YuHi Qiuyun Yu,
Solved wonderfully!! Thank you very much for your quick response.
Best regards,
Fred