Multiple Dates used in Created Column

[PaulCoi]

Hi Community,

I have 2 tables. One is a Sales Data table and one is a date table.

There are 2 dates in the Sales Data table - Close Date and Created date. 

Within my dates table I have added a column which allow me to filter for the current quarter, depending on today's date:

Quarters Passed = if(Dates[Date] >= TODAY(),-(DATEDIFF(TODAY(),Dates[Date],QUARTER)),DATEDIFF(Dates[Date],TODAY(),QUARTER)),

I can then pull this column into a filter and select 0 and it will always show the current quarter. 

I have my Sales Data table related to my Date table with the close date. So far, I have only needed to use the close date.

I have just received a request to show the number of opportunites that were created in the current quarter. Through some research I was able to find the USERELATIONSHIP syntax so I thought I could use this to create a new column in my dates table so that I could filter for opportunities in the current quarter. I created a second relationship between the tables, this time using the Created Date.

My questions is whether this is possible and if so, how do I utilise the USERELATIONSHIP in the above code to create a new column called Quarters Passed Created?

Thanks

[Greg_Deckler · Accepted solution]

See my Open Tickets quick measure, it was designed for this kind of scenario. 

https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364