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.
Solved! Go to Solution.
Hi,
Measure =
CALCULATE (
SUM ( costofsales[Cost of Sales Expense] ),
costofsales[Cost of Sales Item]
IN {
"Wages - Trainers Training Delivery (Contract)",
"Training - Venue Hire",
"Training - Resources & Printing",
"Training - Accommodation"
},
costofsales[Date] > DATE ( 2021, 5, 31 )
)
Regards
Hi,
Measure =
CALCULATE (
SUM ( costofsales[Cost of Sales Expense] ),
costofsales[Cost of Sales Item]
IN {
"Wages - Trainers Training Delivery (Contract)",
"Training - Venue Hire",
"Training - Resources & Printing",
"Training - Accommodation"
},
costofsales[Date] > DATE ( 2021, 5, 31 )
)
Regards
Hi Jos Thank you. I knew it would be something simple.
Appreciate your prompt reply. 😀
Sure! You're very welcome!
Cheers
Hi Jos
IRT my query above, how do I do "does not contain" those fields? Instead of the IN is there another function I use? I have been looking and trying different things but I haven't got it. Are you able to help me out?
Have you tried combining NOT with IN?
Regards
Thank you @Jos_Woolley Tried that and it worked like a charm. Appreciate your guidance with that one.
Cheers
Karen
Great stuff, glad to know! Cheers, Karen.
Jos
Yes, but I think I put them in the wrong place/order. I will have another go at that and see how I go. Thank you for the push in the right direction.
Cheers
Karen
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 |
---|---|
56 | |
27 | |
24 | |
14 | |
9 |
User | Count |
---|---|
77 | |
61 | |
47 | |
17 | |
12 |