I have a calculation returning the total delivery fees we've collected divided by the number of enrollments during any given period of time.
I tried creating a YoY % change calculation, but it's not returning accurate numbers.
Here's the formula for YoY % change:
Hi @erikriesenberg ,
Please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.
When calculating YoY% of "Averages", we usually have this problem because the DAX try to calculate average for each section. Try creating a variable for Average and then see if it works:
I tried that, but I'm receiving the following error message:
The syntax for 'IF' is incorrect. (DAX(VAR _average = [Delivery Fees Per Enrollment]IF( ISFILTERED('Dates'[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_YEAR = CALCULATE( _average, DATEADD('Dates'[Date].[Date], -1, YEAR) ) RETURN DIVIDE( _average - __PREV_YEAR, __PREV_YEAR)))).
I found the error in the DAX, this is the new DAX formula:
I think the problem that I have is that the [Delivery Fees Per Enrollment] calculation isn't year specific.
So when it tries to run this part of the DAX
DIVIDE( _average - __PREV_YEAR, __PREV_YEAR)
the -average is pulling the Delivery Fees for all years
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.