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