Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Percentage

Hi,   I want to work out the moving percentage of monthly balances vs total gross advance for the same year and create a line chart based on the result. I was trying the below Dax calculation, but...
devanshi's avatar
devanshi
Icon for Helper V rankHelper V
3 years ago

Years = YEAR('Table'[Date])
Total Gross Advance = SUM('Table'[Gross Advanced])
Monthly Balance = SUM('Table'[Balance])
Moving Percentage = DIVIDE( [Monthly Balance],
                                                      CALCULATE([Total Gross Advance], ALLEXCEPT('Table', 'Table'[Year],
                                                                            'Table'[Date] <= MAX('Table'[Date]]))))