Forum Discussion
Generating Variance between 2 data points in column.
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.
Anonymous , 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-5c3243d1f9
1 Reply
Anonymous , 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-5c3243d1f9