Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I have a relationship between a DateDim table (Import) to a OrderFact table (Direct Query).
I'm then calculating the amount of time between two dates, excluding weekends. Calculated column below with error message:
It seems as if there is an issue with the relationship so I went and looked to find this:
I've never seen that type of annotation before for relationships. Without knowing what the opposing carrots mean, I cannot really figure out a resolution.
In addition, to double check on the relationship, I created a table with all of the date fields, which all worked and lined up correctly. For some reason, I cannot enact the calculated column though. I either get the error above, or I get "Calculate is not a function" and that there is no relationshiop between the date columns.
I'm at a total stopping point, any help is appreciated.
Thanks!
Solved! Go to Solution.
@Anonymous,
Numerous DAX functions are not available in calculated columns when using DirectQuery. Examples include CALCULATE and DATESBETWEEN. As far as the caret symbols in the relationship, it's my understanding that this is the notation when joining an Import table to a DirectQuery table.
Proud to be a Super User!
@Anonymous,
Numerous DAX functions are not available in calculated columns when using DirectQuery. Examples include CALCULATE and DATESBETWEEN. As far as the caret symbols in the relationship, it's my understanding that this is the notation when joining an Import table to a DirectQuery table.
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
106 | |
87 | |
75 | |
66 |
User | Count |
---|---|
125 | |
114 | |
98 | |
81 | |
73 |