Forum Discussion

cheeto92's avatar
cheeto92
Frequent Visitor
2 years ago

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 ...
"DAX help"
"DAX help" DAX
DAX
DAX Power BI
talespin's avatar
talespin
Solution Sage
2 years ago

cheeto92 

 

Please share some raw data in table form that covers your scenario.

  • cheeto92's avatar
    cheeto92
    Frequent Visitor
    2 years ago
    Fiscal YearRenewals Signed DateRegions (Central, West, East)
    202302/05/23Central
    202302/03/23Central
    202302/02/23Central
    202402/02/24Central
    202402/02/24Central
    202402/02/24Central
    202402/02/24Central
  • cheeto92's avatar
    cheeto92
    Frequent Visitor
    2 years ago

         

     

    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