Values not exists between two Dates

[mnarmeen]

Hi All,

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 how to get inactive members between two dates in powerbi.

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.

Any help would be appreciated. I am using sql server as a datasource on PowerBI desktop.

[RaulCal]

Hi mnarmeen, 

I have the same problem, ¿Did you solved?

[RaulCal]

Hi mnarmeen,

I have the same problem, did you find a way?

I would be so glad if could help me.

[Greger1337]

Check this out:

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

[mnarmeen]

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]

Maybe you can try to create a measure with COUNTBLANK.

COUNTBLANK(Ordertable[ordercolumn])

https://msdn.microsoft.com/en-us/library/ee634230.aspx