Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have this PowerBI Report pointed to two data sources. A list of stores and a list of surveys in a One(Store) to Many(Surveys) relationship. Each quarter, a survey is submitted with a date/timestamp.
How would I exclude the 'Completed' surveys in the 'Incomplete' list?
Hey @timothywright27
Not exactly sure what your data looks like but you may be able to accomplish this using the EXCEPT function. Give it a look:
https://msdn.microsoft.com/en-us/query-bi/dax/except-function-dax
Hope this helps,
Parker
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |