Forum Discussion
bidataservices
3 years agoFrequent Visitor
Week on week change error
I have a table with dates, previous week value, current week value and week o week change value. I am trying to get week on week change % but cannot get it to work. The measures I have are: Previo...
amitchandak
3 years agoSuper User
bidataservices , Make sure Stock_Age_Calendar is calendar/date table and marked as date table
check
Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4
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.
bidataservices
3 years agoFrequent Visitor
It is already marked as a date table.