Values not exists between two Dates

Question

Hi All,&nbsp;I have to filter out inactive members from my database in certain timeframe and show a count of them in barchart alongwith active members.I have managed to show active members (used order date in slicer to get count of customers who ordered food between those two dates).But i dont know&nbsp;how&nbsp;to get inactive members between two dates in powerbi.&nbsp;Scenario : I have 100 registered members in table. When I select dates e.g 1-Jun-2017 to 12-Jun-2017 it shows me 60 members that have ordered which is correct but I have to show 40 members who haven't ordered between those dates as well in a chart.&nbsp;Any help would be appreciated. I am using sql server as a datasource on PowerBI desktop.&nbsp;

greger1337 · Answer

Check this out:https://powerbi.microsoft.com/en-us/guided-learning/powerbi-learning-3-11c-display-empty-categories/

mnarmeen · Answer

Thankyou for your prompt reply.This shows data which have no value but I have dates in my order data column. I just want to show data that is not between those two dates

greger1337 · Answer

Maybe you can try to create a measure with COUNTBLANK.&nbsp;COUNTBLANK(Ordertable[ordercolumn])https://msdn.microsoft.com/en-us/library/ee634230.aspx

raulcal · Answer

Hi mnarmeen,I have the same problem, did you find a way?I would be so glad if could help me.

raulcal · Answer

Hi mnarmeen,&nbsp;&nbsp;I have the same problem, ¿Did you solved?&nbsp;&nbsp;&nbsp;

Forum Discussion

Values not exists between two Dates

5 Replies

Related content

Edit existing table values

Get first date a value from another column exists

How to copy existing semantic model ?

Replace Value if Column exists

Check if a value exist in another column