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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I
Helper I

Need guidance on unpivot columns



I have 2 table below. Currently One to many relationship. Reference number is unique in table 2.

But now if i unpivot column Approver1 & Approver2, my reference number in table 2 become duplicate not unique...and it will affect the one to many relationship. how do i solve this? 


(Reason why i want to unpivot the column Approver1 & Approver2 is to count who had approved the most payment reference.)





Helper I
Helper I



Anyone can help?

Helper I
Helper I

Anyone can give me some advice?

My target is to calculate which approvers had approved how many documents here. Should i unpivot the columns or there's other options? I also need to calculate dates from 2 diff tables.

Super User
Super User

You could set it up as a many-to-many relationship but make it single directional, so that Table 2 filters Table 1.

@johnt75 hi, john, i make it single directional, but it give me another problem. I wan to calculate the datediff between the 2 tables, after i unpivot the column which become many to many relationship, the datediff in Dax doesn't work anymore.


Should create a separate table to unpivot the columns? Any ideas?

Helpful resources

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors