Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I need to calculate date range dynamically, so I have created a text box like below based on creation date:
and now I can get that value using the below DAX:
To Date = SELECTEDVALUE(Data[Creation Date], Data[Max First Touch Date])
Now I have a drop down value of number of date difference like below:
and have got the value in a measure using the dax:
Day No Selected = format(SELECTEDVALUE('Day No'[Day No],1), "#")
So my requirement is to calculate the 'From Date' when like below:
Selected Creation Date + Selected Day No.
so how can I achieve it? please help
Solved! Go to Solution.
So my requirement is to calculate the 'From Date' when like below:
Selected Creation Date + Selected Day No.
so how can I achieve it? please help
Dates are stored internally as the number days since 31 Dec 1899 , so to add a given number of days to a date you can pretty much just write it exactly how you have it in your requirement
From Date = [Selected Creation Date] + [Selected Day No]
Hi,
I have created a measure like this:
User | Count |
---|---|
94 | |
79 | |
73 | |
63 | |
60 |
User | Count |
---|---|
108 | |
100 | |
77 | |
63 | |
61 |