Month Over selected Month Change. Error after unselect time period.

[Anonymous]

Hi Power BI Gurus, 

I created a MoM measure using the quick measure.   seen as below.   Ideally, I am looking for that users could select several GL peirods instead of showing all the months.  However, when I tried to pick the values from the filter "GL-period", the visual is no longer working.  The error messages shows as below  " Time intelligence quick masure can only be grouped or filtered by the PowerBI provided data hierarchy or primary date column."   

Any idea or advises?  Please help.  Thank you!! 

Best Regards,

Flora

[v-chuncz-msft · Accepted solution]

@Anonymous 

Remove the logical test for IF in the above formula or drag fields from Date Hierarchy to Slicers.

[Greg_Deckler]

First, Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Second, See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...

[TomMartens]

Hey @Anonymous ,

you have to develop your own MoM measure.

For this I recommend reading this article as it covers almost anything about time intelligence:

https://www.daxpatterns.com/time-patterns/

Hopefully, this gets you started.

Regards,

Tom

[amitchandak]

Try to use a date calendar. This seems like a correct formula .Try like examples

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(trailing) = CALCULATE(SUM(Sales[Sales Amount]),(dateadd('Date'[Date],-1,MONTH)))

last MTD (complete) Sales =  CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(ENDOFMONTH(dateadd('Date'[Date],-1,MONTH))))
last year MTD (complete) Sales =  CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(ENDOFMONTH(dateadd('Date'[Date],-12,MONTH))))
last year MTD Sales =  CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-12,MONTH)))

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/