MTD, QTD and YTD calculations

[KRISH80]

I need to calculate the MTD, QTD and YTD total Sales. Our Fiscal Yera beigns in April and ends in Mar. So For us it is FY 2020 and Q1 is Apr-19 to Jun-19, Q2 is Jul-19 to Sep-19, Q3 is Oct-19 to Dec-19 and Q4 is Jan-20 to Mar-20.

I have a measure created called "Total-Wins" and i have a Date Table. I am using the formual : 

Sales QTD = CALCULATE([TOTAL-WINS],DATESQTD(Dates[Date])) but it is returning below  - 

Can someone help me sort this out ? My Quarter should start from Apri-19 here it is treating as Q2. Because of this i guess my total is also showing wrong. Please help.

[kentyler]

Here's an answer from another post

 Greg_Deckler

Super User

Re: Custom Quarter periods used in calculations

‎05-02-2017 09:30 AM

You would need to use a DAX variable and CALCULATETABLE function with that variable formula and use that in place of the DATESQTD. I would replace your DATEADD -1 and QUARTER with an equivalent number of days -90 DAYS for example.

so....

everyplace you have DATESQTD you need to replace that expression with a CalculateTable expression 
you would set the dates you want to use to calculate the quarters by using a parameter table perhaps, or just as variables in your Measure
If you need help with the actual DAX code just holler.

[kentyler]

You would need to use a DAX variable and CALCULATETABLE function with that variable formula and use that in place of the DATESQTD. I would replace your DATEADD -1 and QUARTER with an equivalent number of days -90 DAYS for example.

so....

everyplace you have DATESQTD you need to replace that expression with a CalculateTable expression 
you would set the dates you want to use to calculate the quarters by using a parameter table perhaps, or just as variables in your Measure
If you need help with the actual DAX code just holler.

[KRISH80]

Kindly help me with a Dax code please

[kentyler]

Ok

Can you send my your Power BI File ?

[KRISH80]

Sure. Any email I'd to share?

[kentyler]

ken@8thfold.com

i'm off for the night, but i'll have something for you in the morning