Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Apologies if my subject is unclear, I wasn't sure on the language to use.
I have a set of data similar to this example: https://data2actionltd-my.sharepoint.com/:x:/g/personal/aimee_laird_data2action_co_uk/EcITVcSSC6dNh9...
I think I need to do this as a calculated column rather than a measure, however open to your advice.
I am looking at the how many items were sold to a property. Depending on the item, is the sale classed as a Single or a Dual sale.
E.g.
Water + Bread = Dual
Water + Sugar = Single
Water + Bread + Sugar = Dual
Water = Single
Bread = Single
In my dashboard, I want to show:
Number of Multi sales WTD, MTD and YTD
Number of Single sales WTD, MTD, and YTD
Help please! i've tried all sorts but can't make sense of a solution.
Solved! Go to Solution.
@Aimeeclaird So try something like:
Type =
VAR __Table = FILTER('Table (13)',[Address] = EARLIER([Address]))
VAR __Items = DISTINCT(SELECTCOLUMNS(__Table,"__Item",[Item]))
RETURN
SWITCH(TRUE(),
COUNTROWS(__Items) = 1,"Single",
"Water" IN __Items && "Bread" IN __Items,"Dual",
"Single"
)
I mocked this up in attached PBIX (Table (13)) below sig.
@Aimeeclaird So try something like:
Type =
VAR __Table = FILTER('Table (13)',[Address] = EARLIER([Address]))
VAR __Items = DISTINCT(SELECTCOLUMNS(__Table,"__Item",[Item]))
RETURN
SWITCH(TRUE(),
COUNTROWS(__Items) = 1,"Single",
"Water" IN __Items && "Bread" IN __Items,"Dual",
"Single"
)
I mocked this up in attached PBIX (Table (13)) below sig.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
21 | |
16 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |