Forum Discussion
Excel Edit Assistance
Hi All,
Please could anyone assist by trying to fix up the date table i tried duplicating the spread sheet by removing the Months columns and inserting only Date and actuals COLUMNS so it can read in Power bi but still it is giving me a issue of reading dublicates so please can anyone asssit by fixing my data sheet from the screen shot so it can read Date Table and Actuals so i can create quarters,Months and Years in power bi?
Regards seth
hello snamalok
since there are only months value, so how to define exact date in those months?
Regardless, if you want to get months, quarters, and year value, then you need to transform your excel data.
something like below.
- original data
- unpivot 2025 Annual Target
- unpivot other column except ID, Attribut, and Value (Attribut and Value come from previous unpivot)
- extract Attribut using before SPACE delimiter to get year value
- in power bi, create a calculated column to calculate quarter
Hope this will help.
Thank you.Hi snamalok,
I just wanted to follow up on your thread. If the issue is resolved, it would be great if you could mark the solution so other community members facing similar issues can benefit too.
If not, don’t hesitate to reach out, we’re happy to keep working with you on this.Best Regards,
Hammad.
8 Replies
hello snamalok
since there are only months value, so how to define exact date in those months?
Regardless, if you want to get months, quarters, and year value, then you need to transform your excel data.
something like below.
- original data
- unpivot 2025 Annual Target
- unpivot other column except ID, Attribut, and Value (Attribut and Value come from previous unpivot)
- extract Attribut using before SPACE delimiter to get year value
- in power bi, create a calculated column to calculate quarter
Hope this will help.
Thank you.Hi snamalok,
Thanks for reaching out to the Microsoft fabric community forum.
It looks like you are trying to read a Data table and is unable to do it as you tried duplication and PowerQuery is throwing error with duplicate values. As Irwan has already responded to your query, kindly go through his response and check if the issue can be resolved.
I would also take a moment to thank Irwan, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
Best Regards,
Hammad.
Community Support TeamHi snamalok,
As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue or if you need further help.
If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.
If so, it would be really helpful for the community if you could mark the answer that helped you the most. If you're still looking for guidance, feel free to give us an update, we’re here for you.Best Regards,
Hammad.
Hi snamalok,
I just wanted to follow up on your thread. If the issue is resolved, it would be great if you could mark the solution so other community members facing similar issues can benefit too.
If not, don’t hesitate to reach out, we’re happy to keep working with you on this.Best Regards,
Hammad.
Hi Irwan,
apologies , I was trying to calculate the number of KPI status which are "complete and Incomplete" in a column thus returning value was "2". i want to calculate individual KPI total tied to the KPI Number rather than two distinct value show/displayed it should calculate and give a numerical total of Complete and Incomplete itself? ( Hope This Is Clear)
