Forum Discussion
Helper IIold news
Unknown
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
17 Replies
Olamum- Ashish_Mathur
Super User
Hi,
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.
- Olamum
Hello,
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.