Help Creating a Matirx Table with Different Date Period Columns

[1001]

Hi, is it possible to create a matrix table with four date columns: sales yesterday, sales this week, sales this month, and year to date?

Thanks.

[Ritaf1983]

Hi @1001, Yes, you need to create measures for all your periods and put them on "values".
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[1001]

Hi Rita, thx. Would you know of any DAX examples I could reference to start building this out?

[Ritaf1983 · Accepted solution]

Hi @1001 
Yes again 🙂

If you need it dynamic 
First of all, you need the dim_date and mark it as a date table,see linked tutorial (and you will need some dates slicer) :

https://radacad.com/power-bi-date-or-calendar-table-best-method-dax-or-power-query

if it always according to "today"

ii all bottoms suggestions use TODAy() instead date column from the date table.

Last day sales :

PREVIOUSDAY = 
CALCULATE(SUM(Orders[Sales]), 
PREVIOUSDAY(Date_Table[Date]))

this week sales 
https://www.youtube.com/watch?v=kqr5iyd55Og

mtd / ytd 

https://www.mssqltips.com/sqlservertip/4841/calculating-mtd-qtd-ytd-running-and-cumulative-total-in-...

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[1001]

Thanks Rita, will look over these today. Cheers.