Compare dates in Data table to the calendar dates

[BItoken]

Hi,

I have a table which has 2 dates... a maintenance date and a closed date. I was able to derive the month, year and quarter out of these dates for each mainetenance date and closed date.

Now, I have to create a measure to get the sum of sales where Maintenance date and closed date of the accounts falls in a particular QTR. This QTR (a regular Calendar Date FY QTR format) is supposed to be a sigle select Filter which will have Qtr selection between last 2 years and current FY .  

Is there a way i can get the date in there to compare and what DAX function should i use.

For Example: if I select the Filter slicer FY 2020 Q1: i need to get the sum of sales where the Closed end date and the Maintenance end date Qtr is same as the selected FY Qtr.

[v-eachen-msft]

Hi @BItoken ,

Has your problem been solved? Was my reply helpful to you? If the problem is resolved, you could accept the reply you like.

[v-eachen-msft]

Hi @BItoken .

I created a sample, not sure if it meets your needs.

Here is my sample file for your reference.

[amitchandak]

@BItoken , You can join your dates to a single date table. If the part of the same table only one will ve active.  Others you can activate using userelation

Refer: https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

[BItoken]

Thanks for your reply.

I have joined the cliosed end date and maintenance end date in my main view to the dimdate by creating an alias.

My issue here is i need a regular Date Qtr as a filter int he report to display data  where both these dates match the selected date and get the sum.