When creating a Calculated table using the CALENDAR function the Date column generated by the function can't be used as the many side in a one to many relationship if you pass another function as a parameter.
Here's an example of a Calculated table I've used for testing, when I use the hardcoded date value and the TODAY() function there is no issue, when I try to use the calculated value it will not let me create a one to many relationship using the Date column.
When trying to create the "one to many" relationship the report just flashes up the "Working on it" popup and then nothing happens, no error message and no relationship is created.
I get the same behavior if I create the relationship using the hardcoded value and TODAY function and then try to update the code to use the calculated date value instead, it just flashes up the "Working on it" popup and then does not save the changes to my code.
The issue only persents itself when creating "one to many" relationships, if I adjust the data in the calcualted table to allow for a "one to one" relationship I can create that without any issue. I'm also able to create a "many to many" relationship even though it doesn't make sense for the underlying data.
I've uploaded a report here that shows the behaviour explained: https://www.dropbox.com/s/odcnk3r46zjbtpl/FailedRelationshipDemo.pbix?st=0viw1k4b&dl=0
-
Hongju_Jung
on:
Translation Issue in the Korean Version
- Nameless_LW on: Unable to find latest powerbi gateway STANDARD MOD...
- djordje369 on: Installing an update from template app fails
-
Hongju_Jung
on:
A Typo about Visual Gridline in the View menu (Kor...
- jake18 on: Fix High Vulnerabilities found in On-Prem Data Gat...
- BI_Tiffin on: Power BI Azure Map - Connecticut Geocoding Ambigui...
-
acig
on:
Issue with new card visual - reference labels spac...
- catsamson on: Issues with new card visual displaying an URL imag...
- Shackleton on: Image in New Card Visual (incorrect size)
- Dilshanik on: Issue with new card visual after publishing to PBI...