Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hello all,
I am stuck with a problem that I am really hoping someone can help me with.
I have savings data on a separate table (from query) (CostCentreID - 2015/16 - 2016/17 - 2017/18 etc.), and my main table will have calculated columns to calculate 2016/17, 2017/18 etc. using multipliers from yet another table (I am tackling this part with LOOKUPVALUE).
My question is how can I append the savings rows into my main table where there are exactly named columns (2016/17 etc.). I am happy to create a new table too, but I am unable to do that using UNION.
Please let me know if you need any additional information.
In Power BI Desktop, the calculated column will not be displayed in Query Editor. You can only add Custom Column within Query Editor and use it for appending queries.
Regards,
Hi, did you solve your problem? I'm also triying to append queries with calculated columns.
No,
One solution
rewrite the formula dax in the language m
I'll create a new topic
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
69 | |
57 | |
37 | |
36 |
User | Count |
---|---|
83 | |
67 | |
62 | |
46 | |
45 |