Forum Discussion
Solved
Convert Measure to Column
Hello, I've created a measure for comparing sales order IDs from the latest two dates (today and yesterday) in my data set. I'm comparing the two dates to see which sales orders were new, removed...
Same = COUNTROWS(INTERSECT('TODAY',YESTERDAY)) Removed = countrows(except(YESTERDAY,'TODAY')) Added = COUNTROWS(EXCEPT('TODAY',YESTERDAY))
Here's a link to sample data.
Yesterday's data run had 2885 records. Today's run had 2969. The expected results are as follows:
- 2816 existing records (2816 carried over from yesterday to today)
- 153 added records (153 records present in today's data but not in yesterday's data)
- 69 removed records (69 records present in yesterday's data but not in today's data)
Same = COUNTROWS(INTERSECT('TODAY',YESTERDAY))
Removed = countrows(except(YESTERDAY,'TODAY'))
Added = COUNTROWS(EXCEPT('TODAY',YESTERDAY))