The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi,
can someone help with the following challenge.
I have a table with projects and i would like to display the Total sales price for each projects in a matrix table
from my datasource which i can't impact i have this Project A having 2 different statuses with sales price for each status
how can I can replace the Closed status to Open just for that specfic Project A? as seen in below pic, the outcome i am looking for.
keep in mind that i only want to replace the closed status for Project A only.
Solved! Go to Solution.
Hi,
I actually found another solution that worked in Power Query
This YouTube tutourial helped a lot but really appriciate your support!
hi @jalaomar
Can we use Column, then it will be pretty simple
Hi,
I actually found another solution that worked in Power Query
This YouTube tutourial helped a lot but really appriciate your support!
This is the same what I did with column 🙂, you can set the relevant answer/answers as correct so that it can help others/you can set your own answer as correct as well
Replace your status with this one and you will get the answer
Hi,
almost but it didn't work. instead of status TECO, want both rows as REL.
And not impacting the status of other projects. noticed that other projects had their status changed
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the July 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
109 | |
67 | |
46 | |
41 |
User | Count |
---|---|
186 | |
85 | |
76 | |
74 | |
56 |