Forum Discussion

npatten's avatar
npatten
Icon for Helper II rankHelper II
9 years ago

Transfering column data into multiple columns with DAX

 Transfer column entries into multiple columns in DAX Hi- I work for a hospital and I need some DAX help. I am looking to take a column of donation dates and split it into multiple columns, but pres...
Need Help
Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi npatten

 

Yes it's possible to manipulate the data as you suggest in both DAX and the Query Editor, but I suggest you keen the data as is and use another method to derive the Lapsed, Recaptured flags for reporting.

 

If you'd like help with that then let me know, thought your test dataset might need to mix it up a little to show difference results working correctly.

  • npatten's avatar
    npatten
    Icon for Helper II rankHelper II
    9 years ago

    Phil_SeamarkThank you for your offer of help. I would certainly like to discuss your ideas. What did you have in mind? 

     

    Thanks!

    • Phil_Seamark's avatar
      Phil_Seamark
      Icon for Microsoft Employee rankMicrosoft Employee
      9 years ago

      I guess just a bit more sample data in the orignal format but mix up the numbers dates and values a bit so we can generate some DAX to return the results you need.  

       

       

      • npatten's avatar
        npatten
        Icon for Helper II rankHelper II
        9 years ago

        Phil_SeamarkWow! Thank you for your offer to help. I'll DM you some data and we can go from there. Thanks!