Forum Discussion
Dinamic Paramter and calculate on date
I have specific date, and i want to get for user enter number.
Then to create Measure to calculate new date and if new date > old date then "good" else "error".
i try this so:
1. I define parameter "numeric range"
2. I use with dax -ADDDATE, but sometimes the new date blank- no legality.
3. I use with dax-IF NEW DATE>OLD DATE....
this is doesn't work.
Hi AvichaiBI ,
You create a parameter called "number range" and then the user can slide that parameter so that you get a number? Add that number to the specific date, date to get a new date? If yes, you can just use "+" to add the number like the following:
selectedvalue(table[specific date]) + selectedvalue( parameter[number] )
If i misunderstood you, please provide more details about you want.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- v-chenwuz-msft
Community Support
Hi AvichaiBI ,
You create a parameter called "number range" and then the user can slide that parameter so that you get a number? Add that number to the specific date, date to get a new date? If yes, you can just use "+" to add the number like the following:
selectedvalue(table[specific date]) + selectedvalue( parameter[number] )
If i misunderstood you, please provide more details about you want.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
it's work. tnx 🙂
HI v-chenwuz-msft ,
Now i want to chack the date grether then, between this with Parameter to receiptDate.
ToleransDate is measure, specific date+Parameter, the formula doesn't work.
tnx
