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
req77
Helper I
Helper I

Transform some rows into a new column

Hello,

I have a table with the following structure:

Year_MonthType  Value
2023.01Production    5
2023.01Production_Target   7
2023.01Compliance   8
2023.01Compliance_Target   8
2023.02Production   10
2023.02Production_Target   12
2023.02Compliance   4
2023.02Compliance_Target   6
2023.03Production  15
2023.03Production_Target   13
2023.03Compliance   11
2023.03Compliance_Target   12

 

Rows where the Type column has the value "_Target" indicate that they are rows with target values ​​for the respective Indicator Type (for example, the type "Production" is the actual production value for each month and the "Production-Target" is the expected value for each month). I want to create charts for each Type that show the actual value for each month and a goal line (which shows the "_Target" values ​​for each month), but I'm not able to turn this table into a better way.

My expected table result would be this:

Year_MonthTypeValueObjective
2023.01Production57
2023.02Production1012
2023.03Production1513
2023.01Compliance88
2023.02Compliance46
2023.03Compliance1112

 

 

1 ACCEPTED SOLUTION
Ashish_Mathur
Super User
Super User

Hi,

You may download my PBI file from here.

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

3 REPLIES 3
Ashish_Mathur
Super User
Super User

Hi,

You may download my PBI file from here.

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Amazing, @Ashish_Mathur !!
This worked very well!! Thanks a lot!

You are welcome.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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.