Unable to calculate Time Intelligence under Quick Measure in Power BI Desktop

[Im_Arul_K]

Ive connected to an Analysis Server in Power BI Desktop and tried creating a new Quick measure using Month over Month calculation.

But when i inserted Date in the Quick measure , Im receiving the Below error:
" Only Power BI Provided Date Hierarchies or primary date columns are supported" 

Kindly advise me any solution or method to overcome this error

[Im_Arul_K]

User is not aware of the DAX language and he wants to make use of the Quick measure available in the Microsoft Power BI Desktop.

Yes as you mentioned we are bringing date table from Analysis service.
I used date from date table as per the attached screenshot and still receiving this error

I tried using the other fields too in the base value but still same result

[v-kelly-msft · Accepted solution]

Hi  @Im_Arul_K ,

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")

Check the oringinal post below:

https://community.powerbi.com/t5/Service/Time-intelligence-does-not-work/m-p/279520

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak]

@Im_Arul_K , Are you bringing any date table from the analysis service , they you can create TI measures like

example

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))
last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))
last month Sales = CALCULATE(SUM(Sales[Sales Amount]),previousmonth('Date'[Date]))

In case of quick measure too, try to use date from date table 

Power BI — Month on Month with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
https://www.youtube.com/watch?v=6LUBbvcxtKA