Forum Discussion
parameter selection is not passing values dynamically
Hi, My requirement is to get the "no of days open" which is the date diff between the order date and the date that user passes in the report. To do this, I have Order date already exist in my datas...
Hi Anonymous ,
To filter the data dynamically, we can achieve that by a measure as below instead of parameter in power query.
Measure =
VAR se =
SELECTEDVALUE ( 'slicer'[Date] )
RETURN
IF ( MAX ( 'Table'[date] ) <= se, 1, BLANK () )
Hi,
by mistake I checked accept button instead of reply. Please don't consider it as marked. Not sure how to unmark this as solution.
The solutions I am looking at is to get the date diff between the date and the selected date.but what yiou have sent me is different requirement.
Please see the below image,
from the above if you see I am getting blanck for date difference b/w the order date and date I am selected in. but I am expecting date diff b/w order date & selected date.
A quick help would be appreciated.