The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi all,
I am doing below select column, but i need to fetch only non blank valuesin the selectcolumn any idea on this.
selectcolumns(filter(table,table[column] = vaule),"pol",table[number])
i want table[number] to be not null
selectcolumns(filter(table,table[column] = value && not isblank(table[number])),"pol",table[number])