Holly has a data set with Subtotals. She needs to insert a blank row after each subtotal row and add a calculation to those blank rows.
Table of Contents
(0:00) Welcome
(0:15) Go To Special Tricks?
(0:47) Subtotals
(1:10) Helper column on Total rows
(1:50) Move 1’s down a row
(2:28) Select just 1’s & Insert Rows
(3:00) Select blank cells
(3:32) Entering the formula
(4:30) Favorite Go To Special
Back in the days of COBOL, we called it Greenbar paper. There would be four rows of green and four rows of white. It helps your eye to follow the data across the page.
Today, Microsoft calls this banded rows.
Previously, we did this with conditional formatting and the MOD function.
Today, I am showing you a faster way using the DOSE for Excel add-in.
Save 25% on DOSE for Excel using Coupon Code MrExcel25 at https://mrx.cl/getdose
Do you regularly need to sort Excel worksheet tabs by sheet name?
The DOSE for Excel add-in makes this very easy, without any VBA.
Save 25% on DOSE for Excel using Coupon Code MrExcel25 at https://mrx.cl/getdose
You have a list of cells. You want to add a sequential number before the text in each cell.
This video shows how the DOSE for Excel add-in solves the problem. They actually add the sequential number into the cell. You can specify that the number should be separated from the existing text with a space hyphen space.
Save 25% on DOSE for Excel using Coupon Code MrExcel25 at https://mrx.cl/getdose
How can you select every other row in Excel? This video shows how to use the DOSE for Excel add-in to solve the problem quickly.
Save 25% on DOSE for Excel using Coupon Code MrExcel25 at https://mrx.cl/getdose
How can you convert a number to words spelled out?
Microsoft has a SpellNumber function in an ancient knowledge base article.
Rather than copying that code to your Personal Macro Workbook, the DOSE for Excel Add-In will allow you to quickly convert numbers to words.
Save 25% on DOSE for Excel using Coupon Code MrExcel25 at https://mrx.cl/getdose
In this tutorial, Melissa will demonstrate a method on how to perform multiple exact text match replacements. If you’ve ever had this requirement, there’s a fair chance that you’ve performed a series of replace value steps. There are multiple ways to achieve this result, but Melissa will particularly show how to use the M function Record.FieldOrDefault for this specific use case.
***** Video Details *****
00:00 Introduction
00:49 Data set
01:00 Replacements
01:39 Solution
***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax Continue reading “How To Do Multiple Exact Match Text Replacements In Power Query”
Danny from Stuart Florida noticed that when you group all worksheets in an Excel workbook, you can not protect or unprotect the worksheets. This episode offers two very short VBA macros that you can use to unprotect all sheets and then re-protect them with a password.
You are excited about Field Parameters in Power BI, but then realize you can’t use conditional formatting with them. What the french toast! Don’t despair! Patrick and Adam have some ways to get this working.
Matthias K. Question
https://youtu.be/ksmNfa_K8GQ?t=1011
Let report readers use field parameters to change visuals (preview)
https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters
Apply conditional formatting in tables and matrixes
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting
📢 Become a member: https://guyinacu.be/membership
*******************
Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
🎓 Guy in a Cube courses: https://guyinacu.be/courses
*******************
LET’S CONNECT!
*******************
— Continue reading “Conditional Formatting with Field Parameters in Power BI???”
Holly from Vero Beach gets a report each week with Member ID. She needs to pull in the Member Name from last week’s report. This involves doing a VLOOKUP from one workbook to the other – Holly’s employers is on Excel 2016 instead of 365.