Forum Discussion
hashtag_pete
Helper V
Helper Vcount occurences of multiple values
Hello community, I struggle with the following request: I count the occurence of a certain value (here 50) in multiple columns with this query let
source =
#table(
{"Width A", "...
Change each _ = 50 to
each _ = 50 or _ = 45
AlexisOlson
Super User
Super UserTip: If you need to check for more than just a couple of values, you can use List.Contains instead of a bunch of comparisons combined with "or".
For example, instead of
each _ = 50 or _ = 49 or _ = 48 or _ = 47 or _ = 46 or _ = 45write the following:
each List.Contains({50,49,48,47,46,45}, _)
hashtag_peteHelper V
Helper VThanks, AlexisOlson , I was looking for something similar to the IN statement in DAX, but wasn't succesfull.
This defenitely helps!