The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Hello,
The formula below is failing because I am trying to use the RELATED function on the many side of a 1:many relationship. I've read that it should work using the function "RELATEDTABLE" but I can't seem to get my head around it - please can you tell me how to edit the highlighted code below?
Thank you,
CM
(p.s. I know there are better ways of finding the "count of unique customers for prior fiscal year" but I'm just practicing how to use the functions)
You see here how it works:
https://www.sqlbi.com/articles/using-related-and-relatedtable-in-dax/
Proud to be a Super User!
User | Count |
---|---|
57 | |
54 | |
53 | |
47 | |
31 |
User | Count |
---|---|
177 | |
88 | |
70 | |
48 | |
48 |