Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello!
Any help with this is greatly appreciated!
My Capital 2019 measure works perfectly. My Expense 2019 measure just replacing the "=" with "<>" is not actually taking out the capital numbers. I have a table with capital/expense by year and quarter and I need to separate it out into 2 measures. There are too many expense types to type all of them out so I was hoping to use the dne sign. What am I doing wrong here?? Any help is greatly appreciated!
I think I solved my own problem... For the expense measure, I just needed to use AND && instead of OR || when excluding the capital types.
[insert face palm emoji]
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
6 |