Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DAX multiple conditions

Hello boys and probaly some few girls I have 2 tables. First table is showing city name, amount of services and date. The other table is showing city name, variable costtypes and date columns with ...
Need Help
Show and Tell
  • Icey's avatar
    Icey
    6 years ago

    Hi Anonymous ,

     

    Kindly check the attachment whether help.

    Best Regards,

    Icey

     

    If this 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
6 years ago

Hi Anonymous 

 

I would Unpivot the 2nd table and join on both(city and date) columns to get to the solution.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    Thanks for your answer. I tried to unpivot it, but for some reason I still have date and city to be connected. And both are many to many.
    • amitchandak's avatar
      amitchandak
      Super User
      6 years ago

      Anonymous , Try formula's like updated in last update as new columns

      Cost Type 1 Amount = [Amount]* maxx(filter(Table2, Table1[City] =Table2[City] && Table1[Date] = Table2[Date] && Table1[Variable] ="Cost type 1"),[Cost])


      Cost Type 2 Amount = [Amount]* maxx(filter(Table2, Table1[City] =Table2[City] && Table1[Date] = Table2[Date] && Table1[Variable] ="Cost type 2"),[Cost])

       

      if you want to join , you can create a concatenated column