Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello everyone!
I already broke my brain with a simple task.
I have transactions table with customer_id, service, transactions and dates.
I need to make a calculated column that should display if a customer pay some service by selected filters and calculate count of a customers with flag Y or N (payed or not)
Day 1 | Day 2 | Day 3 | Day 4 | |
Is payed P2P service = Y | 100 | 56 | 3 | 23 |
Is payed P2P service = N | 10 | 15 | 18 | 28 |
My idea is make a simple tool to investigate crosssales over services.
The wording of the problem is hardly comprehensible (that's why you've received no answers yet). Can you please explain this in a clear fashion so that people can understand it and help you? Thanks. Before you do it, please get familiar with this: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
By the way, a calculated column can never respond to a slicer/filter. Ever.
User | Count |
---|---|
51 | |
36 | |
19 | |
14 | |
13 |
User | Count |
---|---|
94 | |
72 | |
29 | |
22 | |
14 |