Forum Discussion
Solved
create calculated field based on calculation between two fields from different tables (many-to-one)
Hi, I have a report in which I consolidate information from 2 tables: table A with orderlines table B with delivery lines there's a many-to-1 relationship between the delivery lines table a...
tvanover , you have to compare them on some common dimension. Refer this datediff example across the table, that will give a good idea https://community.powerbi.com/t5/Community-Blog/Decoding-Direct-Query-in-Power-BI-Part-2-Date-Difference-Across/ba-p/934397#M451
tvanover , you have to compare them on some common dimension. Refer this datediff example across the table, that will give a good idea https://community.powerbi.com/t5/Community-Blog/Decoding-Direct-Query-in-Power-BI-Part-2-Date-Difference-Across/ba-p/934397#M451