Forum Discussion
Streamlining Data: Merging Fixed and Dynamic Tables – Any Tips?
Hi Community Members ! What's the best way to merge a table with fixed data from 2019 to 2023 and another table that keeps updating from ERP software? We're aiming to create a single table displ...
New_hello188 , The first need unpivot. Post that create a date using Month and Year. After that both tables can be joined with common date table
Unpivot Data(Power Query): https://youtu.be/2HjkBtxSM0g
Power Query: When I asked you to create common tables: https://youtu.be/PqfGW6pl1Sw
DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solution-8e3eccb41bda