Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Row and column wise conditional difference

I have created a power BI dashboard to monitor the emails coming to a shared mailbox (MS office 365 account/exchange). I need help to write a dax query to create a new column (Duration in hours). As ...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous , is there any change in the solution you want in the initial post. I posted a solution where email 10 was not matching as email 9 off and email 10 is off too. Have you reviewed that?

  • ImkeF's avatar
    ImkeF
    6 years ago

    Hi Anonymous 

    please check attached solution.

    It contains a DAX and a Power Query solution.

    If you're importing hundreds/thousands of emails, PQ might not play out it's advantages here. 

    Would be interested to hear which version runs faster for your case.

     

     

ImkeF's avatar
ImkeF
Community Champion
6 years ago

Hi Anonymous  

may I ask why you want a DAX-solution for it?

A solution in the query editor would most likely be faster and compress better.

Also: Is it guaranteed that every OFF-event has a corresponding ON-event like in your sample data (and vice versa) or could there be single ON or OFFs without a counterpart?