Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
My table is currently set up as below.
I need to match only the codes (if they match - there maybe a Code for Product A but not for B and Vice Versa) in which case it would leave a blank on the row for the Product which isnt in this example but it will be the case)
I would like the final result like this(ignore the colouring)
@lennox25 , Pivot Product column in Power Query, and then you can have column
if [A] <> null && [B] <> null then "True" else false
Pivot Data(Power Query) :https://www.youtube.com/watch?v=oKByyI09Bno&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=12
or create measures like
A= calculate(sum(Table[No Sold]), Filter(Table, Table[Product] = "A") )
B= calculate(sum(Table[No Sold]), Filter(Table, Table[Product] = "B") )
Result = if(isblank([A]) || isblank([B]) , False(), true() )
Use them in visual with other group bys
HI @amitchandak I know how to Pivot and have Pivoted but the column is not working its syntax error?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
62 | |
59 |
User | Count |
---|---|
197 | |
116 | |
107 | |
77 | |
70 |