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,
There are a few cases in your data where the end date is less than the beginning date. That is obviously not possible. Make corrections there and share the download link of the revised file.
Helper IIHello,
Please find updated data
https://drive.google.com/file/d/1T-rSkz3Aw_j7T5QR-yDvIwkGQlEyh6iG/view?usp=drive_link
I want to be able to see total count of client that served within a fiscal year example 2020-2021 in a table along with other dimensions.
And be able to see in cards, count of client that carried over service to another fiscal year(i.e end date was not in fiscal year 2020-2021)
no matter the slicer choosen fiscal date, there should be count of clients that carried over to
2021-2022
2022-2023 and etc.
Thanks
- Ashish_Mathur
Hi,
Please find attached my PBI file.
Hope this helps.
- Olamum
Thank you so much
- Ashish_Mathur
You are welcome.
- Olamum
Quick question
What about the start and end date field? I didn't see it in the data table. I can't get the calculation done in the Power query
- Ashish_Mathur
Those have been subsumed into the single Date column. Study the transformation steps in the Query Editor carefully.
- Olamum
Hello,
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.