Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Quick Measure QoQ % remove -100%

  Hi,   My dataset only has dates until March 31, 2019, still it shows the my QoQ % measure shows a weird -100% change for Q2 2019. how can I remove that?
Tips and Tricks
parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

Anonymous update your QoQ % measure 

 

For exampe if you have sales current quarter and sale prev quarter to calculate QoQ, update your measure as below

 

QoQ% = <your current QoQ calculation> 
* DIVIDE( [Sales Current Quarter], [Sales Current Quarter])
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago
    Market QoQ% =
    Hey!
     
    I'm using this power BI build in measure to calculate QoQ % . it calculates the changes dynamically as more quarters are added. but for some reason even though i only have data until Q1 (03-31-2019) I get that -100% for Q2. Is this a PB bug?
     
    Thank you!
        
        VAR __PREV_QUARTER =
            CALCULATE(
                [Motor_Market],
                DATEADD('tbl_Consolidated_Global+Can'[Date].[Date], -1, QUARTER)
            )
        RETURN
            DIVIDE([Motor_Market] - __PREV_QUARTER, __PREV_QUARTER)