Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

YTD Average % Calculation

Hello People,   I need help in creating YTD Average % Calculation.   I have created 'Current Month W/Allowance Over90 %' ,'Current Month Underbill/Overbill%' by using following  DAX  Current Mon...
  • technolog's avatar
    technolog
    2 years ago

    To create the Year-to-Date (YTD) average percentage calculations based on your current measures in DAX, you can follow these steps:

    Step 1: Create Measures for Current Month Percentages
    Ensure you have the following measures created:

     

    Current Month W/Allowance Over90 % =
    DIVIDE([Current Month W/Allowance Over 90 $],[Aging],0)

    Current Month Underbill/Overbill % =
    DIVIDE([UnderBill],[OverBill],0)
    Step 2: Create YTD Average Measures
    Now, create the YTD average measures. These measures will calculate the average of the current month percentages from the beginning of the year up to the selected month.

     

    YTD Avg W/Allowance Over90 % =
    AVERAGEX(
    DATESYTD('Calendar'[Date]),
    [Current Month W/Allowance Over90 %]
    )

    YTD Avg Underbill/Overbill % =
    AVERAGEX(
    DATESYTD('Calendar'[Date]),
    [Current Month Underbill/Overbill %]
    )

technolog's avatar
technolog
Super User
2 years ago

To create the Year-to-Date (YTD) average percentage calculations based on your current measures in DAX, you can follow these steps:

Step 1: Create Measures for Current Month Percentages
Ensure you have the following measures created:

 

Current Month W/Allowance Over90 % =
DIVIDE([Current Month W/Allowance Over 90 $],[Aging],0)

Current Month Underbill/Overbill % =
DIVIDE([UnderBill],[OverBill],0)
Step 2: Create YTD Average Measures
Now, create the YTD average measures. These measures will calculate the average of the current month percentages from the beginning of the year up to the selected month.

 

YTD Avg W/Allowance Over90 % =
AVERAGEX(
DATESYTD('Calendar'[Date]),
[Current Month W/Allowance Over90 %]
)

YTD Avg Underbill/Overbill % =
AVERAGEX(
DATESYTD('Calendar'[Date]),
[Current Month Underbill/Overbill %]
)