Forum Discussion

nisha_deepak's avatar
nisha_deepak
Helper III
5 years ago
Solved

checking value is blank

i want to check every column of my report for whether that column conatins value or not,,,if blank means i want add a default value intead of it...IF the column contain blank is type ( number...put 0...
Need Help
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    5 years ago

    nisha_deepak , In power bi isblank can be used to check blank in DAX and null in power query

    New column like

    if(isblank[col1]),0,[col1])

    or

    if(isblank[col1]),0.0,[col1])

     

    Power Query

    if [col1] = null then 0 else [col1]

     

    refer: excel-inside.pro/blog/2018/05/17/comparing-null-values-in-power-query/