Hey everyone. New to this particular board, but hoping to get help.
I am trying to run a COUNTIFS statement that I've used for years. There is a particular column that if blank, I want to ignore it in the COUNTIFS statement which is one of the range/criteria entries as:
That works fine if I have a sheet that has data copy/pasted in it. But using Excel data source query against an azure sas blob URL I generated, it isn't able to figure out what is blank and what isn't using that same formula. But if I go into the sheet that the query injects into and drop down the filter for that column.. the option "blank" is there and I can filter it down.
So to summarize... using the "<>" to check against a field (if it's blank) in a COUNTIFS doesn't seem to work if the data is coming from a query.
To compensate, I used the advanced query editor and added a conditional column that uses ISBLANK logic and then populates a value that I can use in my COUNTIFS. But I was curious if anyone else has run into this or not.
I am trying to run a COUNTIFS statement that I've used for years. There is a particular column that if blank, I want to ignore it in the COUNTIFS statement which is one of the range/criteria entries as:
Excel Formula:
'AZURE PowerBI Support Team RPT'!$B:$B,"<>")
That works fine if I have a sheet that has data copy/pasted in it. But using Excel data source query against an azure sas blob URL I generated, it isn't able to figure out what is blank and what isn't using that same formula. But if I go into the sheet that the query injects into and drop down the filter for that column.. the option "blank" is there and I can filter it down.
So to summarize... using the "<>" to check against a field (if it's blank) in a COUNTIFS doesn't seem to work if the data is coming from a query.
To compensate, I used the advanced query editor and added a conditional column that uses ISBLANK logic and then populates a value that I can use in my COUNTIFS. But I was curious if anyone else has run into this or not.