We're giving away 30 tickets for FREE! Share your story, your vision, or your hustle and tell us why YOU deserve a ticket.
Apply nowWin a FREE 3 Day Ticket to FabCon Vienna. Apply now
Hi, can someone tell if / how I can stop nesting of month within year of a matrix ;
my calendar is ;
Solved! Go to Solution.
The best I've come up with is to go to layout style minimal , layout tablular then
go to rows and toggle off the expand colapse .
Hi @Dicken ,
If you are referring to the nesting like shown below, you can change the layout style to Tabular format by following these steps:
Best regards,
Yes thats what I did and then toggle off the expand colapse.
The best I've come up with is to go to layout style minimal , layout tablular then
go to rows and toggle off the expand colapse .
Hi @Dicken ,
Thank you for sharing your solution with us, we're glad to see that you solved your problem! Please don't forget to accept your reply as solution to help more others facing the same problem to find a solution quickly, thank you very much!
Best Regards,
Dino Tao
yes that would work as well
Thanks for the response I was not wanitn to create a y / m column but thanks for the suggeston.
Hi @Dicken ,
You would create a new column for the Month and Year together, like so:
CalTable =
VAR mindate = MIN(Table1[Date])
VAR maxdate = MAX(Table1[Date])
RETURN
ADDCOLUMNS(
CALENDAR( mindate, maxdate ) ,
"Year", YEAR([Date]) ,
"Sort", MONTH([Date]) ,
"Month", FORMAT([Date],"MMM"),
"Period", FORMAT([Date], "MMM YYYY"),
"YearMonthInt", VALUE(FORMAT([Date], "YYYYMM"))
)
Use the period column instead and of course sort it by the Year Month Int column.
User | Count |
---|---|
60 | |
55 | |
47 | |
38 | |
34 |
User | Count |
---|---|
90 | |
83 | |
69 | |
48 | |
47 |