Forum Discussion
Date + Time Input Variable for Measure
Hi Together,
i got following problem:
I made a Measure, which creates me a new column with 0 or 1 to mark all Timestamps which are inbetween of the two variables of my measure.
InDateTimeRange =
var _rangeStart= DATE(2022,01,01) + TIME(08,00,0)
var _rangeEnd = DATE(2022,01,15) + TIME(08,00,00)
return
IF(
SELECTEDVALUE(Data[TimestampFrom]) >= _rangeStart
&& SELECTEDVALUE(Data[TimestampTo]) <= _rangeEnd
&& SELECTEDVALUE(Data[TimestampTo]) <>BLANK()
, 1, 0)
This measure is working fine for me, BUT the hardcoded red part (DATE + TIME) needs to be changed to something the user can select on the report. Input parameters are not working for me, because they can only store decimal numbers or numbers. The time part is also very important for me, just the date would not be enough..
Thanks a lot!
Lennart
6 Replies
Anonymous , A measure or slicer value can not be used in a calculated column. You need use measure
Hi Anonymous ,
How can I filter a Visual by a date and time range otherwise ?Pls refer this:
Use dimension tables to filter your visuals.
Anonymous For example if you have a DateTime slicer so you can use SELECTEDVALUE() function.
eg. SelectedValue(TableName[DateTime Column])
Hi Anonymous
I just want to confirm if you resolved this issue? If yes, you can accept the answer helpful as the solution or share you method and accept it as solution, thanks for your contribution to improve Power BI.
If you need more help, please let me know.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
