Forum Discussion
Solved
Multiply 2 different columns from 2 tables using datetime as a lookup. The tables cannot be RELATED
Hi, I'm trying to multiply kWh x CO2 based on the timestamp. I have looked through various other solutions, but most of them reference the RELATED function, which doesn't seem to work for me. The...
If you cannot create a physical relationship between tables then use TREATAS function connecting both the tables and calculate a measure.
Regards
DI
If you cannot create a physical relationship between tables then use TREATAS function connecting both the tables and calculate a measure.
Regards
DI