Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
I created the attached model to highlight my problem.
In the tkt table I try to calculate the creation date of the corresponding company.
I have created the creation column which only works when I activate the relationship between the account column of the company table and the company column of the tkt table.
The use of userelationship does not work when this relationship is not active.
It seemed to me that its purpose was precisely to get rid of it.
Hope you'll be fine with my french version.
Thank you for your help.
Solved! Go to Solution.
Thank you, it's working with "new column = maxx(filter(company,tkt[entreprise] = company[account]),company[creation])" to get the date of creation of the enterprise.
Any idea why USERELATIONSHIP is'nt working ?
Hi @Paul_Kuntz ,
If @amitchandak has solved your problem, please accept his reply as a solution so that people who may have the same question can get the solution directly.
Best Regards,
Icey
You are creating a new column to bring what?
You can do that like this
new column = maxx(filter(company,tkt[enterpise] = company[company]),company[ref])
Ideally, the date to the company join should be inactive
Or create a common dim
company = distinct(union(all(tkt[enterpise]),all(company[company])))
Thank you, it's working with "new column = maxx(filter(company,tkt[entreprise] = company[account]),company[creation])" to get the date of creation of the enterprise.
Any idea why USERELATIONSHIP is'nt working ?
Also, use crossfilter to remove the other join.
userelation to add the one relation and cross filter to remove the other.
Add company and remove the date . remove can be done for another table not only for this table.
You have to make sure there are no two paths
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |