Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DAX Help

https://drive.google.com/file/d/1NGZKDUHs_HgNBsxVUBnoArEyc0rjK-aX/view?usp=sharing Hi, Need to convert below data to duration and find the Average Time.   Notes: 1. The source is excel 2. the de...
Need Help
  • JarroVGIT's avatar
    JarroVGIT
    6 years ago

    Don't know what you've tried yet, but see this PBIX for a solution. https://1drv.ms/u/s!Ancq8HFZYL_aiIdb2MZyBmmB9sjtqA?e=anIhrM 

     

    I do some PowerQuery stuff (split column, calculate a DurationSeconds column) and then i've created the measure AverageDuration which returns it into your original format (e.g. 118:46:06)

     

    Let me know if this works for you! Kudo's are appreciated.

     

    Kind regards

    Djerro123

    -------------------------------

    If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

    Keep those thumbs up coming! 🙂

JarroVGIT's avatar
JarroVGIT
Resident Rockstar
6 years ago

Don't know what you've tried yet, but see this PBIX for a solution. https://1drv.ms/u/s!Ancq8HFZYL_aiIdb2MZyBmmB9sjtqA?e=anIhrM 

 

I do some PowerQuery stuff (split column, calculate a DurationSeconds column) and then i've created the measure AverageDuration which returns it into your original format (e.g. 118:46:06)

 

Let me know if this works for you! Kudo's are appreciated.

 

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂