Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Data population error (-100% value)

Hi All -- 

 

Hope to get help please. I just updated my report with the most recent quarter  (2022 Q1) but suddenly found out Q2  QTD Chg is population -100%. Not sure why.

 

Thank you in advance.

 

 

Help

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thank you for the response. 

      Thats the thing, there is no data for Q2. 

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     

    Please share the formula of [QTY Chg] so that we might be able to help to figure out the problem.

     

    Best Regards,

    Jay

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi V-Jay, 

      Below is the formula:

      QTD Chg  = //CALCULATE('Data2'[YTD Chg],DATESYTD('Data2'[Date].[Date]))

      IF(
          ISFILTERED('ICC Reports'[Date]),
          ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."),
          VAR __PREV_QUARTER = CALCULATE(SUM('ICC Reports'[Decimal]), DATEADD('ICC Reports'[Date].[Date], -1, QUARTER))
          RETURN
              DIVIDE(SUM('ICC Reports'[Decimal]) - __PREV_QUARTER, __PREV_QUARTER)
      )
       
       
       
      Thank you.