Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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

Need Help

6 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Anonymous , A measure or slicer value can not be used in a calculated column. You need use measure

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thank you. How can I filter a Visual by a date and time range otherwise ? 

  • Tahreem24's avatar
    Tahreem24
    Icon for Super User rankSuper User
    4 years ago

    Anonymous For example if you have a DateTime slicer so you can use SELECTEDVALUE() function.

    eg. SelectedValue(TableName[DateTime Column])

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Can you give me an example ? I am not able to use Selectedvalue in my formula. 

  • v-xiaotang's avatar
    v-xiaotang
    Icon for Community Support rankCommunity Support
    4 years ago

    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.