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 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
Thanks Rita, will look over these today. Cheers.