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
hpandersen
Frequent Visitor

Making calculation from 2 table with no relation but with same structure

Hi.

 

I need some advice.

I have 2 tables with no relations. But they have same structure:

hpandersen_0-1642402934272.png

Is there any way, I can make calculations as Divide(Table1.Period.Year, Table2.Period.Year). 

I would like to end up with a new table with same sturcture, but just showing the calculations.

 

Thanks in advance for your help.

Hans

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@hpandersen , You have to create a common date/ year table. Otherwise you can analyze only on and total

View solution in original post

3 REPLIES 3
AnkitKukreja
Super User
Super User

Hi! @hpandersen 

 

Agreed with @amitchandak here. I also, want to add either you can create a common date table or you can append your tables into 1.

 

If my response has successfully addressed your question or concern, I kindly request that you mark this post as resolved. Additionally, if you found my assistance helpful, a thumbs-up would be greatly appreciated.
Thanks,
Ankit Kukreja
www.linkedin.com/in/ankit-kukreja1904
amitchandak
Super User
Super User

@hpandersen , You have to create a common date/ year table. Otherwise you can analyze only on and total

Hi.

Guess you are right. Was just hoping for a shortcut.

Thanks anyway.

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.