The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello everyone !
I have built a matrix in Power BI and I would like to create a calculated column in the same matrix. I would like to know if it's possible to use calculated columns I have created previously in the matrix. These calculated columns only exist in the matrix and I need to use them in my formula. In other words, can I refer to specific columns that exist only in the matrix to build a new calculated column ? If it's possible, how can I do it ?
Thank you for your help !
Hi, @Anonymous
May I ask if your problem has been solved? Is the above post helpful to you?
If it does, could you please mark the post which help as Answered? It will help the others in the community find the solution easily if they face the same problem with you. Thank you.😀
Hi, @Anonymous
Yes, an already created calculated column you can almost treat as a normal column, and you can also create another calculated column based on the calculated column.
If your calculated column aggregates data in a matrix and you need to create a calculated column based on the aggregated data, then you may create other calculated columns considering aggregation operations. Or you use measures to help you.
Please consdier sharing more details about it and posting expected result if I didn't understand your question correctly.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous it will be easier to answer if you share some sample data and expected output, it is not clear what you are trying to achieve. Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.