Forum Discussion

Lakka00's avatar
Lakka00
Frequent Visitor
2 years ago
Solved

Weird date filter behaviour

I have a table which works out time values.   I am having issues when filtering it based on date, instead of hiding the irrelevant records it shows ::   The column with the time, is using an expr...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Lakka00 

    In my speculate, there must be some some formatting issue with your [Length] column.

    Please try this measure:

    Measure = 
VAR _len = VALUE(SELECTEDVALUE('Table'[Column1]))
VAR _hour = INT(_len/3600)
VAR _minute = INT(MOD(_len,3600)/60)
VAR _second = MOD(_len,60)
RETURN FORMAT(_hour,"00")&":"&FORMAT(_minute,"00")&":"&FORMAT(_second,"00")

     

    Best Regards

    Zhengdong Xu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Lakka00 

In my speculate, there must be some some formatting issue with your [Length] column.

Please try this measure:

Measure = 
VAR _len = VALUE(SELECTEDVALUE('Table'[Column1]))
VAR _hour = INT(_len/3600)
VAR _minute = INT(MOD(_len,3600)/60)
VAR _second = MOD(_len,60)
RETURN FORMAT(_hour,"00")&":"&FORMAT(_minute,"00")&":"&FORMAT(_second,"00")

 

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.