Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Help on converting excel formula to DAX

Experts,   Need help on below excel formula converting to Dax       Data and Lookup tables       Calculated fields                                       Nov, 2019...
DAX Query
  • sturlaws's avatar
    sturlaws
    7 years ago

    Ok, so this should be solved using calculated columns, and I set it up for you here: pbix

     

    cheers,

    -s

sturlaws's avatar
sturlaws
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Hm, perhaps you could upload a sample excel-file to onedrive or something similar, and provde a link to it here. I can't figure out what you are trying to do from what you have posted.

 

cheer,

S

    • sturlaws's avatar
      sturlaws
      Icon for Resident Rockstar rankResident Rockstar
      7 years ago

      Ok, so this should be solved using calculated columns, and I set it up for you here: pbix

       

      cheers,

      -s

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Thank you so much for your help. Appreciate your time and solution