Forum Discussion
Helper Iline chart comparison over time
Hi,
I want to develop a chart similar to this one.
The purpose is to compare the daily status with previous day, week, month and year.
Any idea about what measures I need or chart?
Thanks in advance
2 Replies
- amitchandak
Super User
Ley , with help of date table .
example
Last Day Non Continous = CALCULATE(sum('order'[Qty]),filter(all(Table),Table[Date] =MAXX(FILTER(all(Table),Table[Date]<max(Table[Date])),Table[Date])))
Day behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd(Table[Date],-1,Day))7 Day behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd(Table[Date],-7,Day))
Rolling 30 day = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD(Table[Date Filer],MAX(Sales[Sales Date]),-30,Day))
Avg Rolling 30 day = CALCULATE(Average(Sales[Sales Amount]),DATESINPERIOD(Table[Date Filer],MAX(Sales[Sales Date]),-30,Day))
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/
