Data population error (-100% value)

[RilwanFlame]

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.

[Anonymous]

Hi @RilwanFlame ,

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

Best Regards,

Jay

[RilwanFlame]

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.

[amitchandak]

@RilwanFlame , Do you have any data in Q2?

Power BI — Qtr on Qtr with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-qtd-questions-time-intelligence-2-5-d842063da839
https://www.youtube.com/watch?v=8-TlVx7P0A0

[RilwanFlame]

Thank you for the response. 

Thats the thing, there is no data for Q2.