Forum Discussion

Creative_tree88's avatar
Creative_tree88
Helper V
4 years ago

richbenmintz

 

Thanks so much!  Presume the rest of the statement i.e

 

=count({<Activity_or_Demand={'Activity'},Financial_Year-={'2099'},Room-={'CTSIM','CTSIM2'},Individual_Exam_Parts_Per_Event-={'CLDTH'}>}Event_Key)

 

is done in the same way.  In Qlikview, to exclude a value it is written -= but I'm guessing PowerBi is different?  Having been so used to Qlikview lingo, it's just a case of getting the basics down, then I should be OK.  Appreciate the really quick reply, thanks v much!

Creative_tree88's avatar
Creative_tree88
Helper V
4 years ago

@richbenmintz

 

That's got it - just having a little bit of a hang up on the <>2099 part.  I guess it could be down to not recognising the formatting???

  • richbenmintz's avatar
    richbenmintz
    Resident Rockstar
    4 years ago

    Hi Creative_tree88 ,

    If the [financial_year] is a number then remove the Quotes. otherwise what is the error you are receiving?