Forum Discussion
Change over time - Relations & Best Practice
hi, Marcus_swe
Please check if the format type Updated from Database is datetime when it is imported. if so, please add a date column by DATE Function
Column = DATE(YEAR(Table1[Updated from Database]),MONTH(Table1[Updated from Database]),DAY(Table1[Updated from Database]))
If not your case, there is something wrong in other steps, please share your sample pbix file for us to have a test.
By the way, for your other requirement, try time-intelligence-functions in dax or have a try on quick measures in power bi desktop.
https://docs.microsoft.com/en-us/dax/time-intelligence-functions-dax
https://docs.microsoft.com/en-us/power-bi/desktop-quick-measures
Best Regards,
Lin
Community Supporthi, Marcus_swe
Please check if the format type Updated from Database is datetime when it is imported. if so, please add a date column by DATE Function
Column = DATE(YEAR(Table1[Updated from Database]),MONTH(Table1[Updated from Database]),DAY(Table1[Updated from Database]))
If not your case, there is something wrong in other steps, please share your sample pbix file for us to have a test.
By the way, for your other requirement, try time-intelligence-functions in dax or have a try on quick measures in power bi desktop.
https://docs.microsoft.com/en-us/dax/time-intelligence-functions-dax
https://docs.microsoft.com/en-us/power-bi/desktop-quick-measures
Best Regards,
Lin
Hi, v-lili6-msft Thank you for the reply.
It was the format of my date column that was incorrect.
I did not know that it was such a differance between Date or Date/Time.
I now got it to work as i tought.
Off to the next challenges :smileyhappy:
**Big thanks for the links aswell!
//Marcus