Forum Discussion
handeling 0 value in power bi table
I am using power table widget, for some years, data is not available. instead of showing 0.00, i want to show "Data is not available". how to do?
i ahve created a column, before creating new column i converted the Amount into text. it works, but shows numbers like 3.547934879496. however i needed only two decimal placed
New_Column = if(or(Sheet1[Amount]="0", isblank(Sheet1[Amount])), "NA", Sheet1[Amount])
