Time period matrix

[Greg]

Hi @Usates.

Thanks for the PBIX. My first thoughts would be to use the period-to-date cumulative total pattern for MTD, QTD, and YTD

Period To Date Cumulative Total (Time Intelligence)

Use the Period To Date Cumulative Total pattern to change the context from the particular selected date to all dates up to and including the current date in the current period. For example, to calculate the cumulative sales for the month to date, quarter to date, and year to date, the following could be used: Sales MTD = // DAX PATTERN NAME: Period to Date (Month) Cumulative Total // NOTES: Use CALCULATE to change the context from the particular selected date to all dates up to and including …

and this forum post for WTD

Week to date calculation

Hi @Matteo-Italy. As with most things in Power BI, there are many ways to solve a problem. Here’s one: Sales WTD = VAR _CurrentDate = SELECTEDVALUE( Dates[Date] ) VAR _CurrentWeekYear = SELECTEDVALUE( Dates[Week & Year] ) RETURN CALCULATE( [Total Sales], FILTER( ALL( Dates ), Dates[Week & Year] = _CurrentWeekYear && Dates[Date] <= _CurrentDate ) ) [eDNA Forum - Week To Date Calculation-1] Hope this helps. Greg

Good luck.
Greg