Рет қаралды 4,440
In this video you will learn how to deal with blank values and NULL in Power BI by using DAX and Power Query .
For this video the datasets used contains some sample data with blank value and NULL .
We will try to work with two scenarios .
First scenario is to filter out or remove the blank value and NULL.
Second scenario is to replace #blank and NULL with values .
First scenario ,to remove Blank we can go to Power Query Editor filtered out Blank or click Remove Empty.To removing Null we can filtered our Null .
By DAX we can create sub table where we can remove blank values
Second scenario
We have NULL in the datasets so by using Conditional Column in Power Query we are replacing Null with blank.
#powerbi #powerbidaxfunction #powerbidesktop #Demand #dax #Functions #daxfunctions #powerbi #powerpivot #daxfunctions #powerbidaxfunction
#BI #hots #marketdemand #aws #analysiswithsourav
================================================= ============================
If You Like The Video, Click On THUMBS UP button, and don't forget to Subscribe To This Channel also press the BELL Icon to get the latest notification for new videos.