Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I'm trying to achive a % change measure for a KPI that calculates the previous days volume and compare it against the current filtered date range volume but the measure to calculate previous days volume is not working. Here is the sample dataset:
Date Impressions
1/20/2021 xxxxx
1/21/2021 xxxxx
1/22/2021 xxxxx
1/23/2021 xxxxx
Lets say i used a slicer and filtered the table for 22nd & 23rd Jan data and now want to show what is the % change in impressions over previous 2 days. Here are the measures i created to calculate total impressions during previous days:
Prev Impressions: CALCULATE (Sum('table'[impressions]),'table'[Date] >= Prev Begin Date && 'table'[Date] <= Prev Last Date)
I dont know why but its giving me BLANK everytime, i have checked the filter interactions as well (its in scope), i have checked the date format between 'Table'[Date] column and measures as well and its the same, and even made sure that there is no other filter acting on it but its just not working. Any help with this will be really appreciated!!!!!
Thanks
Shubham
Solved! Go to Solution.
@Anonymous , You have to use a date table marked as date table.
Refer to my video, why time intelligence fails - https://www.youtube.com/watch?v=OBf0rjpp5Hw
@Anonymous , With help from date table, measure like
This Day = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Date]=max('Date'[Date])))
Last Day = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Date]=max('Date'[Date])-1))
Last Day = CALCULATE(sum('order'[Qty]), previousday('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
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 :radacad sqlbi My Video Series Appreciate your Kudos.
Hi @amitchandak , thanks for replying!! I took a look at the day intelligence functions like ParallelPeriod but it does not offer to shift the dates with Day granularity, like this:
@Anonymous , You have to use a date table marked as date table.
Refer to my video, why time intelligence fails - https://www.youtube.com/watch?v=OBf0rjpp5Hw
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |