Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

two rows per record dependent on date for value

I want to compare the tiers of 2019 vs 2020, by creating a column for each. Some companies may not have a 2019 or 2020 but all have at least one or both, meaning two records. 

 

If a company has 2019 and 2020, it brings the record in twice. and displays the Tier on its own line -- I just need one row per company name. This is my result:

Capture1.JPG

Desired result (THIS IS USING A MATRIX -- BUT DOESNT COVER WHAT I NEED, NEED COLUMN FOR EACH YEAR:Capture.JPG

1 ACCEPTED SOLUTION

Do this on Power Query:

- select your column "Year"

- at "Transform" tab, hit "Pivot Column"

- select your column "Tier"

- on "Advanced options", choose "Don't aggregate"

 

View solution in original post

4 REPLIES 4
bluedatenbrian
Advocate II
Advocate II

Hi Cezar, You can do this:
- replace (blank) values with (null) at column 2020

- order your set by 2019

- fill 2020 down (or up)

- filter yout set by 2019, removing (blank) values

Try this and I think you'll find your solution. 

Greg_Deckler
Super User
Super User

I think you need to unpivot your columns? Hard to tell, Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

@Greg_Deckler 
@bluedatenbrian -- TIER 2019 AND TIER 2020 are the columns im loooking to create

Left is my dataset--Right is desired. Will creating columns with DAX be enough to create those?

Capture.JPG

Do this on Power Query:

- select your column "Year"

- at "Transform" tab, hit "Pivot Column"

- select your column "Tier"

- on "Advanced options", choose "Don't aggregate"

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.