cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Create a DATA Table based on another table

Hi All, 

 

I have a table like this : 

 

IDColorTextureTaste
S01YesYesYes
S02NoNoNo
S03YesYesYes
S04YesNoNeutral
S05NoNoNeutral
S06NoNoYes

 

And I would like a table like this : 

 

 YesNeutralNo
Color303
Texture204
Taste312

 

I can't find how to do that on the report neither on the data section. 

Any ideas? 

 

Thanks in advance! 

 

2 ACCEPTED SOLUTIONS

The reason you're getting blank is because of the formula you've used for Return.

You've used a fullstop instead of a comma in the formula.

I've updated the formula to make it easier.

 

Also another issue you have is that your data has results that are based on Scales table Echelle 2 column

But you've used Echelle 1 column to try to get your results through DAX

So results won't match because the value doesn't match your data table.

As such I've shown this in the Scales table by doing 2 formulas. 1 based on Echelle1 and one based on Echelle2 to demonstrate

 

https://ufile.io/tp83h

View solution in original post

5 REPLIES 5
jthomson
Solution Sage
Solution Sage

Select your ID column in Power Query and unpivot the other columns. Trivial from there to stick the relevant columns into a matrix

Anonymous
Not applicable

@chirayuw Hi, I'm sorry but I'm missing something. When I adapt your formula to calculate each row, I get blanck cells only. 

Would you be kind enough to check my file and let me know what I did wrong? It would help me a lot! 

 

https://ufile.io/orrhr

 

 

The reason you're getting blank is because of the formula you've used for Return.

You've used a fullstop instead of a comma in the formula.

I've updated the formula to make it easier.

 

Also another issue you have is that your data has results that are based on Scales table Echelle 2 column

But you've used Echelle 1 column to try to get your results through DAX

So results won't match because the value doesn't match your data table.

As such I've shown this in the Scales table by doing 2 formulas. 1 based on Echelle1 and one based on Echelle2 to demonstrate

 

https://ufile.io/tp83h

View solution in original post

Anonymous
Not applicable

ok I see now! thank you so much for quick help!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!