Handling NULLS or Blanks in Power Query Power BI Desktop Tips and Tricks (28/100)

[@priyankasahitya7003]

Really thank you sir. I tried many ways and I saw many solutions on internet(Web and youtube). But didn't know why it was not replacing with the text I entered. Your video had the solution. As you told I trimmed and then replaced the empty cells with the text I wanted. Thanks a lot🙂😊🙏👍👌

[@AnalyticswithNags]

Thanks keep learning share this channel with friends and colleagues

[@priyankasahitya7003]

@@AnalyticswithNags sir, profit is taxed with a standard tax slab of 2%. how to calculate tax

[@narendrapawar7347]

​@@priyankasahitya7003 suppose total value is 10,000 where actual value is 8,000 and profit is 2,000 then calculate 2% of 2,000.

[@Data_Goz]

Genius. Wasn't able to figure out issue and after watching it all solved up❤

[@AnalyticswithNags]

glad it helped

[@williamarthur4801]

This may seem a stupid qestion but in the source , what were the blanks? if htey had been empty cells surely they would have loaded to PQ as nulls? all I can think is zero text string = "" .

[@AnalyticswithNags]

Explore the similar problems here, learn.microsoft.com/en-us/answers/

[@ameyaaras4957]

can anyone explain why is trim used before the replace function and how it helps while replacing blanks with null?

[@mounikakota7374]

i have huge data in that data has date filed is there , but in report i can use slicer they can show blank ,how to remove it , and remove empty filter applied but its not load into desktop show an error ,

[@AnalyticswithNags]

Why blank appear in slicer or filter becuase of only single reason. If your fact contains some date that is not part of dimension table. Then blank appears in slicer. So find that entry add the dates in dimension Soon I will make video on this

[@shubhamgophane5414]

@@AnalyticswithNags Can you please share the link if you have made video on this. Thanks for all your Videos. You are Awesome!

[@sadhanagirmal7049]

Hi, how to replace blank/empty text values using dax? I cannot do this in power query as the it is calculated coloumn

[@AnalyticswithNags]

Use Isblank function

[@datalab365]

Nice work

[@AnalyticswithNags]

Thanks keep learning share this information with friends

[@melissaphillips8506]

Thank you for this tip. Great solution!

[@AnalyticswithNags]

Thanks keep learning

[@balajiawari9740]

Very Nice Nag.

[@AnalyticswithNags]

Thanks for watching , share it with your friends.

[@SonaliSawakare]

Sir i have obe question so basicaaly the final outcome is if you have blank cell then put null in it right?

[@AnalyticswithNags]

Yup

[@tsouapirigobert5679]

Thank you for this quick solution

[@AnalyticswithNags]

Thanks keep learning share this channel with friends and colleagues

[@kanyin31]

Thank you!

[@AnalyticswithNags]

You're welcome!

[@DapperDude19]

I have currency column with values like"$200", "200$". How to split symbol and value?

[@AnalyticswithNags]

Watch split column video in power BI tips and tricks playlist

[@Shubbham_12]

Can we do ,from select column + Filter+ uncheck the blank option Why not follow this step?????

[@AnalyticswithNags]

I hope that will filter the records. But what I explained is will replace the blanks / nulls

[@SairamV17]

Thanks a lot ❤️

[@AnalyticswithNags]

Thanks keep learning share this channel with friends and colleagues

[@sanc7753]

Nice one..thanks

[@AnalyticswithNags]

Welcome

[@dhanushug1325]

Sir I have 5 blank rows, but I know the catagorical valves it is 5 different categories related to other columns, can you please tell me how to fill manually 5 different values in empty row

[@AnalyticswithNags]

Explore the similar problems here, learn.microsoft.com/en-us/answers/

[@PhillipLearnTeach]

How to replace date nulls with blanks. I tried to do so but it fails

[@AnalyticswithNags]

Why you need to be blanks

[@pourushpatil1306]

How to delete Null and blank spaces in rows(other than selecting and deleting them)

[@AnalyticswithNags]

Not sure what is your question

[@سعدالسلمان-ي4ش]

You'r smart

[@AnalyticswithNags]

Thanks keep learning share this channel with friends and colleagues

[@rutujaatre11]

How to replace null values into blank spaces in power bi ??

[@AnalyticswithNags]

Nulls and blanks are same

[@shamalchavan08]

How to handle a situation where null or blanks are in the column which has date as data ?

[@AnalyticswithNags]

Check playlists of this channel and explore topics on the similar line requested by you.

[@iamawanderer8098]

Why cant we replace the null values with others directly

[@AnalyticswithNags]

can you explain more

[@aqyaanalam6187]

You sound like Sadguru

[@AnalyticswithNags]

Not sure it is positive or negative comment 😜

[@piyushpuri8560]

Bewakoof bana rha h phele seek kr aa bhai dhang se

[@_badboikiller_]

most wasteful video seen

[@AnalyticswithNags]

sorry it didn't work for you

[@Gato_elgamer]

boring

[@AnalyticswithNags]

Thanks for letting me know. Will try to make more interesting