Hi
I have a set of monthly data in multiple financial years from 1 Aug to 31 July. I need to compare the last month of each financial years, such as July-21, July-22 and the month to date value of the current financial year which could be Aug-22 this month, then Sep-22 next month... the last month value in the financial year.
I can select July for the previous financial year, but I need to pick the latest month value in the current financial year for comparison. Please could anyone give me an idea how to use Dax to get the last month value for financial year? Thanks.
I have a set of monthly data in multiple financial years from 1 Aug to 31 July. I need to compare the last month of each financial years, such as July-21, July-22 and the month to date value of the current financial year which could be Aug-22 this month, then Sep-22 next month... the last month value in the financial year.
I can select July for the previous financial year, but I need to pick the latest month value in the current financial year for comparison. Please could anyone give me an idea how to use Dax to get the last month value for financial year? Thanks.
