Specifically, it doesn't generate any error message, the syntax, in that sense, is correct. It's as if TOPN simply doesn't fulfill its function, it doesn't select the number of rows that the variable represents. I have tried transferring all that information to a measure and using it ...
Forum:Power Tools B TOPN of 3 Other Columns I'm fairly new to PBI so please be gentle. I know Excel and VBA so any DAX input should be fine, I'm just not used to PBI terminology or syntax yet. So, I have a dataset that is simple, but huge (5million+ rows). It is set up...
I also get a warning of syntax error if I try to input table name manually. Any help will be highly appreciated. topn = calculate([total kpi], topn(5,' Labels: Need Help Message 1 of 9 914 Views 0 Reply All forum topics Previous Topic Next Topic 8 REPLIES v-juanli...
QUERY SYNTAX Thanks & Regards,BhaveshLove the Self Service BI.Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos. Message 4 of 6 6,806 Views 0 Reply BhaveshPatel Community Champion In response...
Seems like a syntax error but I don't see why. It seems to only accept a caclulated field. Message 3 of 11 844 Views 0 Reply amitchandak Super User In response to Anonymous 03-01-2020 08:05 AM Try like. if (RankCSTVolume<=10, firstnonblank('CSTs from 2018 to curren...