cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

## Graph values between dates?

I have two values, open, and close date. I would like to show a graph showing how many stores were open at that certain date. So something like the x axis would be dates, and the y axis would be how many places were open at those dates. But I wasn't sure how to make the column do that. Any help would be appreciated!

1 ACCEPTED SOLUTION
Community Support

@Greg_Deckler Great idea.

@pantherfanrh I would like to make @Greg_Deckler's suggestion more perfect. Assume the end date is blank, means the store still open until now. So we can create a measure like this:

Measure = CALCULATE(COUNTA(Table1[Store]),FILTER(ALL(Table1),'Table1'[Open]<=MAX('Calendar'[Date]) && ('Table1'[Close]>MAX('Calendar'[Date])|| 'Table1'[Close]=BLANK())))

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Community Support

@Greg_Deckler Great idea.

@pantherfanrh I would like to make @Greg_Deckler's suggestion more perfect. Assume the end date is blank, means the store still open until now. So we can create a measure like this:

Measure = CALCULATE(COUNTA(Table1[Store]),FILTER(ALL(Table1),'Table1'[Open]<=MAX('Calendar'[Date]) && ('Table1'[Close]>MAX('Calendar'[Date])|| 'Table1'[Close]=BLANK())))

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Frequent Visitor

This was so helpful! It worked perfectly. Thank you so much!

Super User

Probably a similar solution that I suggested here:

https://community.powerbi.com/t5/Desktop/Number-of-members-to-any-date/m-p/180695

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...