Excel Edit Assistance

[snamalok]

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

[Irwan · Accepted solution]

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.

[snamalok]

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)

[Anonymous]

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 Team

[Anonymous]

Hi @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.

[Anonymous · Accepted solution]

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.

[snamalok]

Hi Irwin ,

Noted Tried it , but still confused , i"ll send you the Snapshots that i have being working on. I have dublicated all data sets to the date tabl This is the excel duplicated data

power bi counts dublicated values

e but tried to get

1. Distinct Count for the KPI status but still returns two it should aleast count the Number of KPi achieved and Number of KPI Unachieved without calculating the dublicates
2. and Sum of the otput indicator in values 
3. how to calculate text without calculating the duplicatesDuplicated Sets in ExcelCalculates the dublicates also

[Irwan]

hello @snamalok 

i am kinda confused, can you describe more what is your requirement and your expected result from that sample table.

Thank you.

[Anonymous]

Hi @snamalok,
We noticed there hasn’t been any recent activity on this thread. If your issue is resolved, marking the correct reply as a solution would be a big help to other community members. If you still need support, just reply here and we’ll pick it up from where we left off.

Best Regards,

Hammad.

[Irwan · Accepted solution]

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.