Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Quick Measure MoM%

Hi When using the MoM% quick measure Power BI is also returning values for the last month PLUS 1. I.e. If my last period is May 2017, then the quick measure calculates the MoM% for June 2017 which c...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    Anonymous

     

    Hi, made a adjustment to the quick measure. Add before a condition to evaluate the Date.

     

    Value MoM%-Modified = 
If (VALUES(Table1[Date])<>BLANK(),
IF(
	ISFILTERED('Table1'[Date]),
	ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy."),
	VAR __PREV_MONTH =
		CALCULATE(SUM('Table1'[Value]), DATEADD('Table1'[Date].[Date], -1, MONTH))
	RETURN
		DIVIDE(SUM('Table1'[Value]) - __PREV_MONTH, __PREV_MONTH)
))

    Regards

     

    Victor

    Lima - Peru

Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

Anonymous

 

Hi, made a adjustment to the quick measure. Add before a condition to evaluate the Date.

 

Value MoM%-Modified = 
If (VALUES(Table1[Date])<>BLANK(),
IF(
	ISFILTERED('Table1'[Date]),
	ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy."),
	VAR __PREV_MONTH =
		CALCULATE(SUM('Table1'[Value]), DATEADD('Table1'[Date].[Date], -1, MONTH))
	RETURN
		DIVIDE(SUM('Table1'[Value]) - __PREV_MONTH, __PREV_MONTH)
))

Regards

 

Victor

Lima - Peru

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Thanks so much Victor! 

This worked just prefect !