Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi All, can I get some suggestion on how can I accomplish this. The scenario is that I have two columns in a table and I want to create a table visual that would create an inclusion or exclusion list. The sample data is user_id & project_id.
Creating inclusion list of users is easy as I you can use slicers and select the project_id but I am having a hard time to create an exclusion list of users, these are users that doesn't have a project id. Example scenario below and how the output should look like:
Selected project_id | Selected project_id | ||||
1 | 1 | ||||
user_id | project_id | Inclusion List | Exclusion List | ||
A1 | 1 | A1 | A3 | ||
A2 | 1 | A2 | A4 | ||
A1 | 2 | ||||
A3 | 2 | ||||
A1 | 3 | ||||
A2 | 3 | ||||
A4 | 4 | ||||
A1 | 4 |
Do I need to create a DAX formula for this or is this something I need to do in Power Query?
Solved! Go to Solution.
First of all, PQ doesn't interact with viz canvas at all; any change on report / data / model view doesn't influence PQ.
As to your question, it's fairly easy
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LeanAndPractise(Everyday) ) |
First of all, PQ doesn't interact with viz canvas at all; any change on report / data / model view doesn't influence PQ.
As to your question, it's fairly easy
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LeanAndPractise(Everyday) ) |
Awesome! Thank you!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
22 | |
21 | |
19 | |
13 | |
12 |
User | Count |
---|---|
41 | |
31 | |
25 | |
23 | |
23 |