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

Need Help

Irwan
1 year ago
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.
Anonymous
1 year ago
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

Frequent Visitor

1 year ago

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

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
and Sum of the otput indicator in values
how to calculate text without calculating the duplicatesDuplicated Sets in ExcelCalculates the dublicates also