Forum Discussion
Understanding date hierarchy
when you let power bi create the date hierarchy you are using, power bi in the backend will create w table for each date column that you have in your model .
when you use year from the hierarchy, your are using the year from the hidden table.
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-auto-date-time
best practice :
disable auto/ datetime from the options , and create your year date table with the columns that you need .learn here how to create date able using powr query :
https://radacad.com/all-in-one-script-to-create-date-dimension-in-power-bi-using-power-query
let me know if this works for you .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
Community Champion
when you let power bi create the date hierarchy you are using, power bi in the backend will create w table for each date column that you have in your model .
when you use year from the hierarchy, your are using the year from the hidden table.
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-auto-date-time
best practice :
disable auto/ datetime from the options , and create your year date table with the columns that you need .
learn here how to create date able using powr query :
https://radacad.com/all-in-one-script-to-create-date-dimension-in-power-bi-using-power-query
let me know if this works for you .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠