Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello Power BI Community,
I'm experiencing a peculiar issue with my Year-over-Year (YoY) DAX formula in Power BI. The formula works correctly for the years 2018, 2019, 2020, and 2021, but fails to return values for 2022. Here's what I've already checked and confirmed:
At this point, I'm at a loss for what else to try. The formula has been reliable for other years, and nothing ostensibly seems wrong with the data or setup for 2022. If anyone has encountered a similar issue or has any insights on what might be causing this anomaly, your assistance would be greatly appreciated.
Thank you in advance for your help and suggestions!
Solved! Go to Solution.
Hi @asuprunova ,
Here I create a sample to have a test. My measure is similiar like yours and it will work.
Relationship:
Measure:
LaborForceTotal = CALCULATE(SUM('LaborForce'[Value]))
YoYLaborForce% =
VAR PYRecepts =
CALCULATE(LaborForce[LaborForceTotal],DATEADD('Date'[Date],-1,YEAR))
RETURN
DIVIDE([LaborForceTotal]-PYRecepts,PYRecepts)
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @asuprunova ,
Here I create a sample to have a test. My measure is similiar like yours and it will work.
Relationship:
Measure:
LaborForceTotal = CALCULATE(SUM('LaborForce'[Value]))
YoYLaborForce% =
VAR PYRecepts =
CALCULATE(LaborForce[LaborForceTotal],DATEADD('Date'[Date],-1,YEAR))
RETURN
DIVIDE([LaborForceTotal]-PYRecepts,PYRecepts)
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
70 | |
36 | |
21 | |
18 | |
15 |
User | Count |
---|---|
126 | |
30 | |
28 | |
24 | |
22 |