Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
My data is like below:
Course No. | Language | State
AZ-999 | EN-US | To Do
AZ-999 | ZH-CN | Doing
AZ-999 | JA-JP | To Do
AZ-888 | EN-US | To Do
AZ-888 | ZH- CN| To Do
AZ-888 | ES- ES | Done
I need these to display like:
AZ-999 | EN-US, ZH-CN, JA-JP| To Do, Doing, To Do
AZ-888 | EN-US, ZH-CN, ES-ES| To Do, Done
While this still responding to the filter "Language" and "State".
I mean like below, when Languaage ES-ES is selected in the slicer, I want the "Languages" column in the table shows only the ES-ES, the languages column is generated using table.join
pls try this
_Language = CONCATENATEX('Table',[Language],", ")
_State = CONCATENATEX('Table',[State],", ")
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |