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.
Hi
I'd like to know if the following is possible.
I have a matrix report and the columns are taken from a fact table called RentCharges. This table has a list of different rent charges ( Rent, Service charge, Ground maintenance, Lift) for each property.
I'd like multiple attributes from the property dimension table listed - i.e for each property, its full address is listed - and not for example just is property reference.
I know one way I could do this is create a new column in powert query (or dax) that concatenates the address together - but ideally I would like the fields to remain separate.
A screen shot of the type of thing I am trying t acheive is shown below.
Many thanks in advance.
Solved! Go to Solution.
@micahelw , I think you need a new column
@micahelw , I think you need a new column
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 | |
60 |
User | Count |
---|---|
197 | |
118 | |
108 | |
78 | |
69 |