Dinamic Paramter and calculate on date

[AvichaiBI]

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.

[AvichaiBI]

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

[AvichaiBI]

it's work. tnx 🙂

[v-chenwuz-msft · Accepted solution]

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.