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.

     

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thank you amitchandak . Please refer my comment below as well.

amitchandak's avatar
amitchandak
Super User
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
    Community Champion
    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.