Forum Discussion
DAX for Week Over Week comparison between two years
Hi Everyone. I have a task where I need to calculate week over week lease renewal comparions between two years and broken down by Regions. In my Renewal Report table I have a column named "Signed ...
The excel table and the chart is what i need to recreate in Power BI. I created two measures in Power BI like this:
Signed_Renewals_2023 =
CALCULATE(
COUNTROWS('Renewal Report'),
FILTER(
'Renewal Report',
'Renewal Report'[FY] = 2023 &&
NOT(ISBLANK('Renewal Report'[Renewals Signed Date]))
)
)
Signed_Renewals_2024 =
CALCULATE(
COUNTROWS('Renewal Report'),
FILTER(
'Renewal Report',
'Renewal Report'[FY] = 2024 &&
NOT(ISBLANK('Renewal Report'[Renewals Signed Date]))
)
)
I need to show the %ofRenewals signed this week last year vs %of Renewals signed this week of current year. This is what the bar chart is showing for the central region