Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi, When i merge two table i am getting rows with null, the 1st table is 2017 and 2 is 2018 the data from 2018 is to the right of the 2017 period data and all looks good untill i have a account or store or line desc that did not exist in 2017 but it is in 2018, I am trying to find a way merge the first 3 columns (account, store, Line DESC) any ideas?
Thanks Z
Solved! Go to Solution.
Hi @zibster,
Based on my test, after I replaced the "null" value to 0, I could just remove the left three columns to get the result you want:
You could downloadn the pbix file to have a view, if I misunderstand you, please just let me know.
Regards,
Daniel He
Hi @zibster,
Could you please post me your desired result?
Regards,
Daniel He
Hi,
below is the desired result Thanks:)
What do you see in Power Query? I've just done the same thing, and just filtered null out to load. Also what join did you do?
HI,
As you can see on my first pic the account, store and line_desc for 2018 is to the right of the data and where i have CHECK as line_desc in 2018 date it shows null in 2017 on the left, this is done with full outer join as some items did not exist in 2017 or in 2018. so i actuly can have null showing for the 2017 or for 2018 set. I know how to replace the Null values for the periods but i do not know how to combine the first 3 colums with last 3.
Thanks
Z
Hi @zibster,
Based on my test, after I replaced the "null" value to 0, I could just remove the left three columns to get the result you want:
You could downloadn the pbix file to have a view, if I misunderstand you, please just let me know.
Regards,
Daniel He
Thanks for yout help Daniel
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
86 | |
79 | |
54 | |
39 | |
35 |
User | Count |
---|---|
102 | |
82 | |
48 | |
48 | |
48 |