Forum Discussion
Previous Day Sales in Column
Hi all, How can I get Previous Day Sales in a Sales Transaction table? Tried below but its giving incorrect result. Column 2 =
VAR _Yesterday = DATEADD ( 'calendar'[Date], -1, DAY )...
pls try to create a measure, not a column
calculate( SUM ( [SalespersonIncentive] ),DATEADD ( 'calendar'[Date], -1, DAY ))
Hi ryan_mayu , I am trying to create a calculated column to get the total correct. with the measure it is showing incorrect total.
could you pls provide some sample data and expected output?