Forum Discussion

Danche1's avatar
Danche1
Copper Contributor
Aug 26, 2024

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...
  • Harun24HR's avatar
    Aug 26, 2024
    Use BYROW() or MAP() function. Like =BYROW(G2:G50000,LAMBDA(r,IF(r<>"", r, ""))).

Resources