Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hello and Happy new year!!
I have this data model in my Power BI Desktop file:
The dot line is a inactive relation between this tables because I can't relate them directly (it's show an error message that it would generate ambiguity between the tables Custormers and HistoricalInvoicesLines). How can I relate this tables? I need to know for a Record[CodRecord] which are the SUM(HistoricalInvoicesLines[Amount]) for this record.
Thank you!
Solved! Go to Solution.
Hey,
you should use
USERELATIONSHIP(<columnName1>,<columnName2>)
It explicit uses a relationship for calculating a measure.
https://msdn.microsoft.com/en-us/library/hh230952.aspx
https://www.sqlbi.com/articles/userelationship-in-calculated-columns/
Greetings.
Or use this model approach:
Hey,
you should use
USERELATIONSHIP(<columnName1>,<columnName2>)
It explicit uses a relationship for calculating a measure.
https://msdn.microsoft.com/en-us/library/hh230952.aspx
https://www.sqlbi.com/articles/userelationship-in-calculated-columns/
Greetings.
Great!!! Thank you very much, the USERELATIONSHIP function is the solution.
Hi
In this case you have check the data inside this entities or you can create one more entity by having distinct records and link it with Historical.
Regards,
V