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 Month W/Allowance Over90 % = DIVIDE([Current Month W/Allowance Over 90 $],[Aging],0)
Current Month Underbill/Overbill% = DIVIDE([UnderBill],[OverBill],0)
Now I need to YTD Average % calculation based on the above two calculations.
This is what I am looking for
YTD Avg W/Allowance Over90 % = Average of Current Month W/Allowance Over90 % ( This average should be from Jan to selected month)
YTD Avg Underbill/Overbill%= Average of Current Month Underbill/Overbill% ( This average should be from Jan to selected month)
Sample Pbix with current month calculations
I have attached the sample Pbix.
Any help would be really appreciated.
Thanks,
Fareed.
