Forum Discussion
datediff with userelationship
Anonymous ,Can you share sample data and sample output in table format?
Here is the full code, but I cannot share the file. Actually the formula is working.
However, when I try to create a "group" from this column, I am getting a circular reference error and I need this group for something else. The circular error reference is referencing the SF_Opportunity Line table, which is not related directly to the Date Table (the Date Table is directly related to the SF_Opportunity table, and the Opportunity Line table is related to the Opportunity table).
Kumail amitchandak The expected output is the result of the IF statements in the formula. All I'm needing is to know how to incorporate UseRelationship into my VAR statement. I'm thinking it might be the cause of the circular error that I am getting when I try to create a group from this calculated group.
Previously my date table was connected directly to the Opportunity Line table, and now it is connected to the Opportunity table (the header table for Opportunity).So, my idea was to try and utilize UseRelationship in my VAR statement to see if that helped.
You can use USERELATIONSHIP() dax function to activate inactive relationship when you have multiple relationships between table in your model.
In order to have a working solution, you may need to send the .pbix file if the above still doesn't solve your problem.
Regards
Kumail Raza
Did this help? Kudos are appreciated.
Consider Accept it as the solution to help the other members find it more quickly!!
You can use USERELATIONSHIP() dax function to activate inactive relationship when you have multiple relationships between table in your model.
In order to have a working solution, you may need to send the .pbix file if the above still doesn't solve your problem.
Regards
Kumail Raza
Did this help? Kudos are appreciated.
Consider Accept it as the solution to help the other members find it more quickly!!
