DAX Formula for current end of quarter date

[RustyNails]

Hello all,

I have a simple request. I want to count the number of items that are projected to ship before the end of current quarter. Is there a formula that will allow for something like:

Forecast = Calculate(Count(Product[Item]), product_ship_date <= EndOfCurrentQuarterDate(Today()))

So if use Forecast today it should give me the count of all items that are planned to ship on or before 6/30/2018. And then in Q3, it should bring everything that's planned for Q3 and so on.

There is EndOfQuarter function, but it's not accepting Today() or Now(). I've tried creating a date table, but it was getting complicated. Was hoping for a more simpler solution. Any help around this?

[Greg_Deckler · Accepted solution]

Funny enough, I just recently created just such a quick measure and put it in the gallery:

https://community.powerbi.com/t5/Quick-Measures-Gallery/First-Last-Working-Days/m-p/391545

[RustyNails]

Hi Greg, I tried to download the PBIX file but it's saving as compressed Zip format (changing the extension is not working)

[Greg_Deckler]

@RustyNails- Strange, I just downloaded the PBIX and opened it no problem, and it came down as a PBIX. Send my your email in private message and I'll mail it to you.

[RustyNails]

Ah was able to sort this out. Thanks!

I was also able to get last day of quarter (instead of working day). But I can't seem to compare the product_ship_date to it (says I cant compare the date to a true/false expression)