Forum Discussion

danextian's avatar
danextian
Icon for Super User rankSuper User
9 years ago
Solved

Quick Measure time over time comparison showing future dates

Hi All,   I'm not sure  if I am the only one  having this  issue. I have a  data that is only until March. When I created a quick measure, Power BI also added April but with zero values so this cre...
Need Help
  • danextian's avatar
    danextian
    9 years ago

    GilbertQ,

     

    Hi, I am no sure what you mean.

     

    I ended up doing this:

     

    Value MoM% = 
var MaxDate = CALCULATE(max('raw data - unpivoted'[Month]),all('raw data - unpivoted'[Month]))
var myValue = 
IF(
	ISFILTERED('Calendar'[Dates]),
	ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy"),
	VAR __PREV_MONTH =
		CALCULATE(
			'raw data - unpivoted'[Value],
			DATEADD('Calendar'[Dates].[Date], -1, MONTH)
		)
	RETURN
		DIVIDE('raw data - unpivoted'[Value] - __PREV_MONTH, __PREV_MONTH)
)
	RETURN IF(
		myvalue=-1,blank(),myValue
)

    I added  this 

    myvalue=-1,blank(),myValue
danextian's avatar
danextian
Icon for Super User rankSuper User
9 years ago

@i GilbertQ, i tried your approach but still not working.

by the way im doing  an MoM %

Using Power BI's quick measure feature, I created a mon over month % change.

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
9 years ago

Hi danextian

 

Ok possibly change the ISBLANK measure not to the calculated measure but the SUM measure that you are using

 

In your example it will be the [Value] to replace

  • danextian's avatar
    danextian
    Icon for Super User rankSuper User
    9 years ago

    GilbertQ,

     

    Hi, I am no sure what you mean.

     

    I ended up doing this:

     

    Value MoM% = 
var MaxDate = CALCULATE(max('raw data - unpivoted'[Month]),all('raw data - unpivoted'[Month]))
var myValue = 
IF(
	ISFILTERED('Calendar'[Dates]),
	ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy"),
	VAR __PREV_MONTH =
		CALCULATE(
			'raw data - unpivoted'[Value],
			DATEADD('Calendar'[Dates].[Date], -1, MONTH)
		)
	RETURN
		DIVIDE('raw data - unpivoted'[Value] - __PREV_MONTH, __PREV_MONTH)
)
	RETURN IF(
		myvalue=-1,blank(),myValue
)

    I added  this 

    myvalue=-1,blank(),myValue
    • v-ljerr-msft's avatar
      v-ljerr-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      9 years ago

      Hi danextian,

       

      Great to hear the problem got resolved! Could you accept your helpful reply as solution to help others who may also have the similar issue easily find the answer and close this thread? :smileyhappy:

       

      Regards