topic Re: Data population error (-100% value) in DAX Commands and Tips

Data population error (-100% value)

Anonymous — Mon, 25 Apr 2022 13:58:01 GMT

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.

Re: Data population error (-100% value)

amitchandak — Mon, 25 Apr 2022 16:36:04 GMT

Anonymous , 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

Re: Data population error (-100% value)

Anonymous — Mon, 25 Apr 2022 16:38:44 GMT

Thank you for the response.

Thats the thing, there is no data for Q2.

Re: Data population error (-100% value)

Anonymous — Fri, 29 Apr 2022 07:21:36 GMT

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

Re: Data population error (-100% value)

Anonymous — Fri, 29 Apr 2022 12:48:50 GMT

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.