Forum Discussion
RELATED function not working
Hello, I am trying to calculate net work days between a starting and ending point but am having trouble. I am following the solution in this thread: https://community.powerbi.com/t5/Desktop/DATE...
Hi Anonymous ,
The first step would be to remove the blank rows in your Holi table. You can do this in your source data or via Power Query:
= Table.SelectRows(Source, each [Date] <> null and [Date] <> "")
Then delete and re-create your relationship between the two tables so that it is 1-to-many instead of many-to-many.
This should allow the RELATED function to operate as expected.
RELATED works only from Many to 1 side.....u have Many to Many between tables