Forum Discussion

Advocate II

5 years ago

Solved

DAX Assistance Required

Hi Team, Here is my query: Table 1 Account Financial Date Financial Value AB 1/05/2021 35 Table 2 Account Consumption...

Advocate II

5 years ago

Thank You for your comprehensive answer Jihwan. I have attached my pbix file. could you kindly have a look and advise?

I get an error as "A table of multiple values was supplied where a single value was expected"

Super User

5 years ago

Thank you for your feedback.

Please check the link down below, and please check if I understood your question correctly.

I could not know which columns to show in the new table.

I suggest doing this in Power Query Editory.

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

kagy100
Advocate II
5 years ago
Thanks Jihwan_Kim. Ideally, my preference would be DAX but I guess Power Query also does the trick.