Data

[Acalmeida21]

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? 

[Anonymous]

@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 · Accepted solution]

@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.