Forum Discussion
Fiscal year comparison
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
2 Replies
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
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
