Forum Discussion
Help Creating a Matirx Table with Different Date Period Columns
- 3 years ago
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
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-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
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
- 10013 years agoResolver II
Thanks Rita, will look over these today. Cheers.