Forum Discussion
Solved
Parameter (or variable) to use different tables?
Hello, I have a few tables, all with different names (let's say Question1, Question2 etc - it's survey data), but each containing the same named fields: Respondent ID Attribute Value I'...
Hi s--turn
Sounds like you need to UNION here which will help you to slice and dice
https://learn.microsoft.com/en-us/dax/union-function-dax
Regards,
Ritesh
Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users
Thanks so much, both Jaywant and ribisht17 ! Jaywant - reading your solution was so interesting and taught me some things I didn't know before. I was all poised to try it - and then Ribisht17 came in with an incredibly simple idea which I couldn't resist, and which solves the problem perfectly! (I've actually used Append in Power Query rather than UNION in DAX, with an extra column for the query name, but same principle). Thanks so much, both of you 🙂