Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi
I'm a newbie so there may be a pretty obvious solution, so sorry in advance 🙂
I have set up my Power BI report with 2023 data. Now that I have the report set up I want to add 2022 data. I did this by merging queries in Power Query. So now my 2023 data and 2022 data is merged in the one data table and renamed Data.
However, I noticed the added columns that I used in the 2023 (for example Index) didn't update for the data 2022. For example when I check the dataset, the 2023 data is indexed and the 2022 data is empty. In Excel you would drag the formula down, how do I do this is in Power Bi? Or do I need to add all the added cloumns into the 2022 data before merging it with the 2023 data?
Thanks in advance for your help!
KatieK
Sorry I should mentioned that the added columns are all calculated columns. It is the calculated columns (one example is index) that are not updating with the added dataset.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.