DAX Subtract Pivot Table Columns Measure

[Anonymous]

Hello,

I am relatively new to DAX and I am stuck at one point where I am trying to calculate the difference between two dates.

For example, the current setup of the table looks like this:

The 1 that we can is coming from a measure that I have created

CALCULATE([Total_Red_count],FILTER('Coles Data','Coles Data'[FW_END_DATE_MAX]=FIRSTNONBLANK('Coles Data'[FiscalWeekEndDate],'Coles Data'[FiscalWeekEndDate])))
return result

Now, the next step that I can't seem to figure out is how should I subtract those columns within DAX. For instance, how should I go about subtracting 2/08/2020 from 28/06/2020. The answer should be 0. I need to do this across the entire table and then aggregate this by -1 and 1. -1 means the product was removed and 1 would be that the product was added. Happy to post more examples if you require.

Can anyone please assist with this?

Thank you

[Anonymous]

@Anonymous 

I don't see logic behind that how can you get an integer like 0, 1 when subtracting two dates. Normally it returns how many days.

I guess you mean subtracting the [Total_Red_count] between the two dates? In this case, can you also show the dax for [Total_Red_count].

Paul Zheng _ Community Support Team