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