Fiscal year comparison

[PrasadVelan]

Dear Experts,

I need a help

I have a table with 2 fiscal years 1 column is the order received FY and another is billable FY, I would like to arrive at the deferred billing amount for the next FY.  The sample data is here

PO NO	P.O. DATE	FY	DUE DATE for billing	Billable FY	Order Value
Po00007	29-Jul-20	2018-19	01-Aug-20	2020-21	5,000.00
Po00007	29-Jul-20	2018-19	01-Nov-20	2020-21	5,000.00
Po00007	29-Jul-20	2018-19	01-Feb-21	2020-21	5,000.00
Po00007	29-Jul-20	2018-19	01-May-21	2021-22	5,000.00
Next FY
our FY is Apr-Mar

Thanks in advance

Prasad

[v-angzheng-msft]

Hi, @PrasadVelan 

Not very clear to me, could you please consdier sharing more details about it or expected result so it is clear on what needs to be implemented?

Best Regards,
Community Support Team _ Zeon Zheng

[GilbertQ]

Hi @PrasadVelan 

You could use the TOTALYTD DAX measure which will allow you to specify the End date, which would be your fiscal month which would be 03-31

Here are more details to do this: Calculate Financial Years To Date (FYTD) Sales In Power BI Using DAX | Enterprise DNA