Forum Discussion
Helper IIold news
Hi,
Please find attached my PBI file.
Hope this helps.
Thank you so much
You are welcome.
Those have been subsumed into the single Date column. Study the transformation steps in the Query Editor carefully.
Thanks
Super UserHi,
Please find attached my PBI file.
Hope this helps.
Helper IIHello,
I validated the solution by placing start date and end date side by side. if you look at the picture, the start date was 2/3/2020 which falls under fiscal year 2019-2020
But it ended in another fiscal year 2020-2021 and it was not counted. For every year the service is still on, it should be counted.
Thanks
- Ashish_Mathur
I obviously cannot make any good use of a picture. Anyways, ensure that there is the FY calculated column formula in the Calendar Table is correct.
- Olamum
Certainly, it exists. Can you reverse the initial date and final date so I can verify and return it to you? This is because I'm unable to test it since the information cannot be extracted from the columns.
I mean instead of removing it, you should have it to test the values. Thanks- Ashish_Mathur
What exactly are you trying to say. I am completed lost.