This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is upgrading! Read all of the details including the timeline and what you can expect. Learn more
Hey,
(struggling since 2 weeks, I tryed vlookup, summarize function but didn't been able to FIX it)
I created a culomn with the first "word" of items in my product table, to use as a keyword.
So actually, I have multiple items having same key word (it is my first objectif). Then I created measures to identify rather an item has a good sell or no.
I wanted to precise that even if an item haven't a good sell but the keyword of this item have a good sell so it's not a problem. So I did same measures by key-word, but when I display the result in separate table with (single table for products column, and single one for key-words) it works, but when I put the results in a single table it gives me results by product items.
I want to be able to summarize the result by key-word for all the products and display the right value in a column.
Thanks to mush for the one that Will help me.
Would be easy with excel, just a Vlookup was sufficient.
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.