Forum Discussion
Matrix report with Multiple dates
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