Forum Discussion
Solved
Measure to isolate specific field
Hi all - new to this! have been using Qlikview for years and now we are transferring over to PowerBI so need to brush up on syntax used for certain measures. I use the measure = DISTINCTCOUNT('T...
Please see the attached PBIX, created a measure that could work
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???
Hi Creative_tree88 ,
If the [financial_year] is a number then remove the Quotes. otherwise what is the error you are receiving?