Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi.
I need some advice.
I have 2 tables with no relations. But they have same structure:
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
Solved! Go to Solution.
@hpandersen , You have to create a common date/ year table. Otherwise you can analyze only on and total
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.
@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.
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |