Monday, 28 April 2025

Catogorizing Last 30 Days, 60 days,90 days in Power bi

Link to Video Tutorial -> https://www.youtube.com/watch?v=hDopw1mPlrU

 Step-1 ->Create a seprate calulated table as shown below

Period = 
VAR
    _last30days = ADDCOLUMNS(
        CALCULATETABLE(
            'Calendar'
            ,DATESBETWEEN( 'Calendar'[Date], TODAY() - 30, TODAY() )
        )
        , "In the last", "30 days"
    )
VAR
    _last60days = ADDCOLUMNS(
        CALCULATETABLE(
            'Calendar'
            ,DATESBETWEEN( 'Calendar'[Date], TODAY() - 60, TODAY() )
        )
        , "In the last", "60 days"
    )
VAR
    _last90days = ADDCOLUMNS(
        CALCULATETABLE(
            'Calendar'
            ,DATESBETWEEN( 'Calendar'[Date], TODAY() - 90, TODAY() )
        )
        , "In the last", "90 days"
    )
RETURN
    UNION( _last30days, _last60days, _last90days )


Step-2 --> Crate a bidirectional Link to Calender and period table






No comments:

Post a Comment