Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

last Fiscal year QTD required using DAX

Need Last Fiscal year same quarter .

Current Quarter is FY18-Q4 --01jan2018 to 12 jan 2018

 

Desired Output is FY17-Q4----01jan2017 to 12 jan 2017

 

Fiscal year starts from 01'April to 31'March

 

We have date field ddmmmyyy and sum(sale) .

Can someone pls assist me in DAX 

No Replies