Forum Discussion
iDAXntKnow
3 years agoNew Member
SharePoint list Calculation
Hi All, I am very new to PowerBI and DAX. I did a bit of SSRS reports, but I've been given a task and I don't know how to do it correctly. We have a SharePoint list (onprem), that contains TeamCo...
v-yinliw-msft
3 years agoCommunity Support
Hi iDAXntKnow ,
You need to add a column or new a table that indicate the relationship between the country and the Teamcode, and if you want to add two columns side by side, you should add the column to the Value.
Like this:
You can refer this documentation to create a matrix:
Create a matrix visual in Power BI - Power BI | Microsoft Learn
Hope this helps you.
Best Regards,
Community Support Team _Yinliw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.