Forum Discussion
Substract time columns from diff datasets
Dear Mentors, I need to substarct column "EST Start" from "EST" ...basically trying to calculate delay. "EST" indicates schedule - Source is dataset1 "EST Start" indicate actual start time - s...
Hey Thanks rohit1991 Deku danextian ...... actually problem is - It dose not pull out column name from other datasource.
We can substract 2 columns from same data source - but if you try to select another datasource columns , Power BI is not giving me option to select from other datasource.
Can Iconnect with anyone of you ?
Thanks
Mangesh M
Can you please show your diagram/relationship view? If there's a direct one-to-many relationship between the two tables, you should be able to use RELATED on the many side. The RELATED function cannot be used on the "one" side of a one-to-many relationship because there could be multiple matching rows in the related table, and RELATED does not perform aggregation.