Forum Discussion
Can't replicate Microsoft Tutorial for the Time Intelligence Function
So, I am trying to learn the basics of Power BI. I am trying to figure out how do the time intelligence functions work. I am looking at this page: https://support.powerbi.com/knowledgebase/articles/...
I think I found my mistake. My date field was actually a new column created within Power BI. Once I made a column in the original Excel file instead - the problem disappeared
When using the time inteligence functions ensure that your date field is label as a data type of date within power bi desktop. Edit Query -> Home -> Select your date field and ensure that data type is listed as date.
I checked it, and it is in the correct format.
I think I found my mistake. My date field was actually a new column created within Power BI. Once I made a column in the original Excel file instead - the problem disappeared