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

2 Replies

  • parry2k's avatar
    parry2k
    Super 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)