Forum Discussion
Solved
Not recognizing date relationship
I am trying to create a column to compare two dates but the error is saying there's no relationship. This is a many-to-one relationship from a schedule to a list of records. Both dates are formatted ...
Thank you for the help, I ended up changing the storage to Import which fixed the relationship so it was no longer limited.
Hello, mkohler281 ,
the brackets represents a "Limited relationship" and RELATED is not supported in those:
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand
You can have a workaround or resolve the "limited relationship".
The Workaround can look like this:
Column =
var currentRow = 'fact'[Test]
var matchingRows = MAXX(FILTER(dim, dim[dim] = currentRow), dim[dim])
return matchingRowsyou don't even need a relationship for that:
Thank you, but it looks as though this does not work in Direct Query.