cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sandy_a
New Member

Tabular turn row records into category columns grouped by date

I'm fairly new to Tabular, DAX and Power BI although I have a history with SSAS and SSRS.  

 

I was hoping someone could point me in the right direction of how to achieve the following with a Linked Tabular model (i.e. I can't apply the groupings in the Power BI report)

 

I have a data table in the following record format:

sandy_a_0-1621037389292.png

 

Which I'm trying to display in Power BI in the following group format:

sandy_a_1-1621037428403.png

 

This is where I've been able to get to by creating a 'Total' measure with DAX Calculate(Sum(Table[Amount]), Filter(Table, Table[Type] = "A")). 

sandy_a_2-1621037623677.png

 

 

Do I need to create Measures or a Calculated Group in my Tabular model (or something else)?  

 

Thanks in advance for any help you can give me.

 

 

1 ACCEPTED SOLUTION
sandy_a
New Member

Solved - just needed to use a Matrix visual in Power BI

View solution in original post

1 REPLY 1
sandy_a
New Member

Solved - just needed to use a Matrix visual in Power BI

View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.