Excel Edit Assistance

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.