Forum Discussion
Help Creating a Matirx Table with Different Date Period Columns
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.
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-queryif 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=kqr5iyd55Ogmtd / ytd
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
4 Replies
Hi Rita, thx. Would you know of any DAX examples I could reference to start building this out?
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-queryif 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=kqr5iyd55Ogmtd / ytd
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
