Forum Discussion
Danche1
Aug 26, 2024Copper Contributor
Automatizing a process - automatically populating a cells
Hi Everyone, I'm trying to automatize a process where with the data from excel file i have created a Power BI dashboard. Long story short, I have one column "Column 5" where it's copying the dat...
- Aug 26, 2024Use BYROW() or MAP() function. Like =BYROW(G2:G50000,LAMBDA(r,IF(r<>"", r, ""))).
Harun24HR
Aug 26, 2024Bronze Contributor
Use BYROW() or MAP() function. Like =BYROW(G2:G50000,LAMBDA(r,IF(r<>"", r, ""))).