Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 months ago
Solved

Data transform using power query

Could you please someone suggest me for below issue. Thank you in advance. I have below format data  2026 actual     budget       p1 p2 p3 p1 p2 p3 revenue 1 2 3 4 5 6 ...
Dataflow
Need Help
Tips and Tricks
  • v-echaithra's avatar
    v-echaithra
    6 months ago

    Hi Anonymous,

    The updated PBIX file is attached for your reference.
    Here, the data has been reshaped to the required format (Subject, Year, Period, Actual, Budget) using Power Query so that it can be used directly for reporting and further analysis.

    Please review the updated file and let us know if everything looks good or if any additional adjustments are needed.

    Thank you.

  • v-echaithra's avatar
    v-echaithra
    6 months ago

    Hi Anonymous ,

    We’d like to follow up regarding the recent concern. Kindly confirm whether the issue has been resolved, or if further assistance is still required. We are available to support you and are committed to helping you reach a resolution.

    Best Regards,
    Chaithra E.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
6 months ago

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Anonymous's avatar
Anonymous
Not applicable
6 months ago

lbendlin Thankyou for your recommendation. I updated the data sample. Can you please suggest how to do it?