Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
see first post
Does this help @v-xuding-msft ? Please let me know if I can add more details for a better understanding of my need.
Thanks
I have edited the first post for a more straightforward description of the problem.
Thanks in advance for your help.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
98 | |
78 | |
65 | |
60 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |