Generating Variance between 2 data points in column.

[jaydonguyen]

I am looking to create a variance column that will show the difference between 2 publish dates.

below is the data structure.

trying to create a column that show the variance between the dates.

here is how i currently have the PBI matrix setup.

over time there will be monthly updates appended to this table so i am trying to make it so if you filter 2 dates it will show the difference between the columns.

i know to do this in tableau but it is not easy in pbi.

[amitchandak · Accepted solution]

@jaydonguyen , Not very clear, but I feel you need a difference between noncontinuous dates. Make sure you join the date table with the date column not the DateTime

example

Last Day Non Continuous = CALCULATE([sales],filter(ALLSELECTED('Date'),'Date'[Date] =MAXX(FILTER(ALLSELECTED('Date'),'Date'[Date]<max('Date'[Date])),'Date'[Date])))

Last Day Non Continuous = CALCULATE([sales],filter(ALLSELECTED('Date'),'Date'[Date] =calculate( max(Sales[Sales Date]), FILTER(ALLSELECTED('Date'),'Date'[Date]<max('Date'[Date])))))

Day Intelligence - Last day, last non continous day
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c324...