Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
50 | |
23 | |
18 | |
18 | |
13 |
User | Count |
---|---|
91 | |
85 | |
46 | |
28 | |
21 |