Break down contract duration per fiscal year

[Anonymous]

Edit for a more clear description of the problem.

Hello, 

I have this table:

client	contract start date	contract end date
x	april 2019	march 2020
y	october  2020	september 2022

Knowing that fiscal years start on October, I want the duration of each contract per fiscal year:

client	contract start date	contract end date	FY19 duration (mo)	FY20 duration (mo)	FY21 duration (mo)	FY22 duration (mo)
x	april 2019	march 2020	6	6	0	0
y	october  2020	september 2022	0	0	12	12

How can I create these colums in DAX (or M Query?)

Many thanks

[v-xuding-msft]

Hi @Anonymous ,

I don't understand clearly about your requirement. Can you please share some sample data and your expected results?  Then we will solve it quickly.

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

see first post

[Anonymous]

Does this help @v-xuding-msft ? Please let me know if I can add more details for a better understanding of my need.

Thanks

[Anonymous]

I have edited the first post for a more straightforward description of the problem.

Thanks in advance for your help.