Forum Discussion

J918's avatar
J918
Frequent Visitor
2 years ago
Solved

Datediff slicer not correct

I have this DAX code to show how many minutes a process ran:  Process Time Minutes = DATEDIFF(META[PROCESS_START_TIME], META[PROCESS_END_TIME], MINUTE)   I then put a slicer: However, it's ...
  • J918's avatar
    J918
    2 years ago

    I figured it out.  Changed my DAX to:

     

    Process Time Minutes = DATEDIFF(META[PROCESS_START_TIME], META[PROCESS_END_TIME], SECOND) / 60
mark_endicott's avatar
mark_endicott
Icon for Super User rankSuper User
2 years ago

J918 - The slicer is turning the correct values for what you are doing. In order for this to work, you will need to turn your column into an integer for minutes, try:

 

 

DATEDIFF(META[PROCESS_START_TIME], META[PROCESS_END_TIME], SECOND) / 60

 

 

If this works, please accept it as a solution.