Forum Discussion
Dynamic dates
Sakaraipandian you can create another table that contains the festival date and name of the festival and then use that as a slicer for users to select the festival, and then use the date from the festival date to get the sales for the last 30 days.
Last 30 Days Sale = VAR __festivalDate = MAX ( YourFestivalTable[Date] ) VAR __startDate = __festivalDate - 30 RETURN CALCULATE ( [Sales Measure], DATESBETWEEN ( YourCalendarTable[Date], __startDate, __festivalDate ) )You might need to tweak it a bit but this will get you started.
✨ Follow us on LinkedIn
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Sakaraipandian you can create another table that contains the festival date and name of the festival and then use that as a slicer for users to select the festival, and then use the date from the festival date to get the sales for the last 30 days.
Last 30 Days Sale =
VAR __festivalDate = MAX ( YourFestivalTable[Date] )
VAR __startDate = __festivalDate - 30
RETURN
CALCULATE (
[Sales Measure],
DATESBETWEEN ( YourCalendarTable[Date], __startDate, __festivalDate )
)
You might need to tweak it a bit but this will get you started.
✨ Follow us on LinkedIn
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Is it work for every year