Forum Discussion

sumneshnepalia's avatar
sumneshnepalia
Frequent Visitor
2 years ago
Solved

filter data on report refresh time

We have data in following format from Direct query and I need to filter a graph on last refresh time    i.e. timestampvalue from "TIMESTAMP" column equal to timestampvalue from "Current time" trie...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi sumneshnepalia ,

     

    This logic you're talking about holds true in the row context when creating calculated columns:

    And I created a measure, at this point the filter context works, you can also use SELECTEDVALUE instead of MAX:

    You can test the formula I've given and let me know if you have any problems, or clarify in your next reply if I've misunderstood what you've said.

     

    Best Regards,
    Zhu

     

    If there is any 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

Thanks for the reply from lbendlin.

 

Hi sumneshnepalia ,

 

please try the following DAX:

 

Measure=IF(HOUR(MAX('A'[TIMESTAMP]))&MINUTE(MAX('A'[TIMESTAMP]))=HOUR(NOW())&MINUTE(NOW()),1,0)

 

The visual is then filtered using measure:

 

Result:

 

Best Regards,
Zhu

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

  • sumneshnepalia's avatar
    sumneshnepalia
    Frequent Visitor
    2 years ago

    Anonymous  I think this logic will compare max timestamp for the date but I need the flag for current time stamp = time stamp of the date

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi sumneshnepalia ,

       

      This logic you're talking about holds true in the row context when creating calculated columns:

      And I created a measure, at this point the filter context works, you can also use SELECTEDVALUE instead of MAX:

      You can test the formula I've given and let me know if you have any problems, or clarify in your next reply if I've misunderstood what you've said.

       

      Best Regards,
      Zhu

       

      If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.