Learn in power bi: how to replace value based on condition in power query. Conditional value replacement with if statement on multiple columns. #powerbi #dax #2023 Prepare for PL 300 certification, expertise in the leading BI tool, Mastering Power BI #powerbipro #powerquery #dax #learnpowerbi #amitchandakdak

Abstract Thesis 131: Power Query how to replace value based on condition

--Content
00:00 Introduction
00:30 Power query Conditional Replacement
03:00 Power Query Replace Value

Last Video:
Abstract Thesis 130: Learn Power BI: Power Query- create Star Schema from Single Table: youtu.be/-yDv6FD547o

file: github.com/amitchandakpbi/powerbi/blob/main/For%20Beginner%20Tutorial%20Series%20You%20Tube.xlsx

github.com/amitchandakpbi/powerbi/blob/main/For%20Beginner%20Tutorial%20Series%20You%20Tube.xlsx

Last Video:
Learn in Power BI using DAX, how to do Active Employee Tenure Bucketing, get Hired, Terminated, and Active employees: youtu.be/fvgcx8QLqZU

Watch full series
Expertise Power BI: youtube.com/watch?v=59PUFuuCrbY&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L

Last Video:
Power BI How to create two columns (split) and formatted financial Profit and Loss (PnL) Statement, Balance sheet. Traditional income statements, P&L, and Balaesheet have a format with blank rows in between, and total across rows.

Power BI create two columns format Profit and Loss Statement AT 120: youtu.be/WLg85yiMgHI

The Blog Link: amitchandak.medium.com/power-query-across-table-calculated-column-718809a97fd
The file Link: community.powerbi.com/t5/Quick-Measures-Gallery/Power-Query-Across-Table-calculated-column/td-p/2926509

Customer Retention Part 1:
community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-1-Month-on-Month-Retention/ba-p/1361529

Customer Retention Part 2: Period over Period Retention community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-2-Period-over-Period-Retention/ba-p/1377458

Customer Retention Part 5: LTD Vs Period Retention
community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-5-LTD-and-PeriodYoY-Retention-is-only/ba-p/2114497

Last Video: Abstract Thesis 87: Power BI Tooltip Page: How to pass selective values to the tooltip page: youtube.com/watch?v=lEq7YtkxeLU

This link will take you to the power bi dashboard that has links for all my blogs and video -You can get all my posts at
community.powerbi.com/t5/Data-Stories-Gallery/Blog-Analysis/m-p/1265567#M4403
Like, Share, comment, and Give suggestions for improvement, and the next post/video.

Important Links every power bi enthusiastic should bookmark: amitchandak.medium.com/important-links-every-powerbi-enthusiastic-should-bookmark-5682c7a3c912

DAX Calendar - Standard Calendar, Non-Standard Calendar, 4-4-4 Calendar
youtube.com/watch?v=IsfCMzjKTQ0&t=145s

Also, check
Cheat Sheet — Power BI Time Intelligence Formulas Using Today - medium.com/chandakamit/cheat-sheet-power-bi-time-intelligence-formulas-using-today-654f26e27304

Cheat Sheet — Power BI Calendar that starts with any date of the month — Just two variables apart - medium.com/chandakamit/cheat-sheet-calendar-that-starts-with-any-date-of-the-month-just-two-variables-apart-9fb9a0f65b92

-~-~~-~~~-~~-~-
Please watch: "Microsoft Power BI Tutorial For Beginners✨ | Power BI Full Course 2023 | Learn Power BI"
youtube.com/watch?v=cN8AO3_vmlY
-~-~~-~~~-~~-~-

• Learn Power BI: Power Query Conditional Replace Value AT131 ( Download)
• Power Query Tutorial: How to Conditionally Replace Values Without Creating New Columns ( Download)
• Power BI quick trick…How To Conditionally Replace Values using if..then..else within replace! ( Download)
• Mastering Power Query: Conditionally Replacing Values ( Download)
• Finding and Replacing Column Values in Power Query ( Download)
• 29 - Replace the values in a column on a condition (Power Query) ( Download)
• Replace values faster in Power Query: 4 tips ( Download)
• How to efficiently replace values in Power Query ( Download)
• Replacing Multiple Values with Example in Power Query New!! ( Download)
• How to Replace values for selected column in Power Query Editor MS Excel 2016 ( Download)
• How to Replace Values, Remove Rows, Choose Columns Using Power Query in Excel or Power BI ( Download)
• Find & Replace Multiple Values Using Power Query ( Download)
• [Power Query] Replace Each x in a Matrix With Column Headers in PowerQuery ( Download)
• Bulk Find-Replace Using List.ReplaceMatchingItems in Power Query ( Download)
• Automatically Find and Replace | Excel Power Query Tips & Tricks ( Download)