Forum Discussion
Can't replicate Microsoft Tutorial for the Time Intelligence Function
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
Thank you! It worked. However, I still can't get my dashboard to do the same. I fully replicated the logic, but my measure doesn't return any results.
I have several locations, and I have a monthly score for each location (I record them into the 1st of every month). As a part of dashboard, I want to have a measure of score increase (difference between any given month and a prior month). That's why I am trying to figure out the prior month using time intelligence function PREVIOUSMONTH.
Is there any more resources to read about this function, besides basic description in Microsoft's knowledge base?
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