Forum Discussion
How to get user selected date as a variable in DAX
Hello everyone,
I have created DAX queries to calculate counts of various records. These DAX queries works based on last_week_start_date, last_week_end_date, next_week_start_date and next_week_end_date.
I was thinking is there a way I can accept user input for these 4 variables so that I no need to hardcode any dates in DAX.
Thanks,
Karthik
3 Replies
- amitchandak
Super User
Anonymous , Two date ranges?
But remember you can not initialize the date ranges
How to use two Date/Period slicers: https://youtu.be/WSeZr_-MiTg
Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=35
or week vs Week
Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123
https://www.youtube.com/watch?v=pnAesWxYgJ8Hello amitchandak ,
Thanks for your response but my requirement was different than your solution. But anyway thanks for your reply.
v-kkf-msftCommunity Support
Hi Anonymous ,
What do you mean about accepting user input? Does it mean selecting a value in slicer or parameters ? What is the output you want?
Best Regards,
Winniz
