Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."),
How does time intellingence work on a data warehouse with own data hierachy or what does primary dat column mean?
Solved! Go to Solution.
Got a solution from PBI support.
========SOLUTION TEXT STARTS========
One easy way to solve the ussie is to transform the date from a text to a date value using the UK format:
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("fVRRcsUgCLxLvjsjYIzmLJl3/2tUGht3ie2fDALLsnBdW9YkOZnosX2+rq2/b7P+mFmSnNPbTbVp6p5k589o9sxtmnYO7x1rNamAaUkVzJbEZmx/S4FUQiDde4C3cCGODf32ovjZG0QYQrFaBhuj7jG8a3IOQiV7LHR7x+dzcPWQI7rAPFI1guFeZXJWsZMNgPEQO2BkBqmMqr3mC6i8BeBKAlfGQgqx/Fm5bpcZSkUbNRhEqCwzhwGpfAoVUhWObaRYBwnkOO2V2QCJ2q939FtfTJZF3SkzYxh10dEwhToKG/rmmTR5siYZZCQnaLKwzCphDgNdaANbMDKDroRX0jVZmEnWBtGe+W4odRRQ9bq47GH3+5vMzCDfV+XvI+MwYNnDJQw89/HhBMOdjKdAaXF8KCezAXXjuHk1/F7xqaeRFa57EDmO2f5lA2b0HNUe+/kG", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Date = _t]),
#"Changed Type with Locale" = Table.TransformColumnTypes(Source, {{"Date", type date}}, "en-GB")
in
#"Changed Type with Locale"
In the Query Editor > Advanced query editor, you have to replace your
#"Changed Type with Locale"= ……………………………….” (whatever is there in middle), please replace this with the below one and close and apply and now run the DAX query will work
#”Changed Type with Locale” = Table.TransformColumnTypes(Source, {{"Date", type date}}, "en-GB")
========SOLUTION TEXT ENDS========
Sorry i can't see the image- can you explain please?
Thank you.
Have updated the image.
You will have to go into File->Options and Settings->Options->Current File->Data Load
Hi
I have the same issue but in a measure. My time intelligence button is ticked.
Do you have any suggestions? I have been spending the last 3 days trying to get the year to date formula working but it is just not happening.
Many thanks!!
I have the same problem. Using Quick measure with Time Intelligence generates Dax-function with this error-message. I have no problem in creating manually the Dax-function for for example TotalYTD. I have a date-table with correct date-cllumn as primary key. So why is the Quick measure not working? I use the latest Power BI Desktop version, I downloaded today.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.