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
Acalmeida21
New Member

Data

Hello everybody, I have an excel report with 03 data columns: Open data - Resolved Data - Finish Data

 

Do i have any dax or relation that i could conect these three informations to build a graphic? 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Acalmeida21 , are these dates?

If yes you need common date table and use userelation to create measure and use date from date table in the visual

 

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

 

or

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

View solution in original post

2 REPLIES 2
V-pazhen-msft
Community Support
Community Support

@Acalmeida21 

You can just drag them into a same visual if all 3 columns are in the same table.

 

If they are separated tables, you may add an index column on each table. Then connect the 3 tables using index column.

 


Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

amitchandak
Super User
Super User

@Acalmeida21 , are these dates?

If yes you need common date table and use userelation to create measure and use date from date table in the visual

 

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

 

or

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

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.

Top Solution Authors