Forum Discussion

RichardsonMM's avatar
RichardsonMM
Frequent Visitor
1 year ago
Solved

Matrix with Year and Month Column

I would like to make this excel table in Power BI, however i find some problems doing it, like, how can i use both year and month in the column of my matrix? I don't want to create two separated matr...
Need Help
  • krishnakanth240's avatar
    krishnakanth240
    1 year ago

    Hi RichardsonMM ,

     

    You can modify the DAX formula for your calendar table:

     

    Calendar =
    ADDCOLUMNS(
    CALENDAR(DATE(2023,1,1), DATE(2025,12,31)),
    "Year", YEAR([Date]),
    "Month", MONTH([Date]),
    "PeriodLabel",
    IF(YEAR([Date]) < 2025,
    FORMAT([Date], "yyyy"),
    IF(MONTH([Date]) = 1, FORMAT([Date], "yyyy"), FORMAT([Date], "yyyy/mm"))
    ),
    "PeriodSort",
    IF(YEAR([Date]) < 2025,
    YEAR([Date]) * 100,
    IF(MONTH([Date]) = 1, YEAR([Date]) * 100, YEAR([Date]) * 100 + MONTH([Date]))
    )
    )

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi RichardsonMM,

I wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.
If the community member's answer your query, please mark it as "Accept as Solution" and select "Yes" if it was helpful.
If you need any further assistance, feel free to reach out.

Please continue using Microsoft community forum.

Thank you,
Pavan.