Matrix report with Multiple dates

[EagerLearner]

I have a visual below which is a Matrix report. For Rows, I have Current date - 1 as 1st row, Current month - 1 as Row 2, Current month in Row 3 and Current year in Row 4. This should be dynamic every month it should be changed Automatically.  Please help me with this. Reference pictures are below Any Idea on this @amitchandak  

Thank you!

#matrixreport

[amitchandak]

@EagerLearner , A calculation group of This day, This month , Last Month, This Year.

Then all measure in another calculation group and edit table for that and add column for inbound, outbount and agent

I have done something similar here. See if this can help

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

if you do not like, this month, this day etc. We need have independent or extended table with today, this month, last month and year data and join with date table and use in visual

Union (

row("Date", today(), "Type", format(today(), "mm-dd-yyyy")),

addcolumn(calendar(eomonth(Today(),-1)+1 , eomonth(today(),0) ), "Type", format([Date], "mmm-yyyy"))
addcolumn(calendar(eomonth(Today(),-2)+1 , eomonth(today(),-1) ), "Type", format([Date], "mmm-yyyy"))
addcolumn(calendar(eomonth(Today(),-1* month(Today()) )+1 , eomonth(today(),12 -1* month(Today())) ), "Type", format([Date], "yyyy"))
)

Join this table with the date table and from the visual remove the blank for this table. this should avoid the need for a calculation group of day and month formula . But the second one is still needed to group the measures