excel formula not calculating
why excel formula is not calculating
when excel shows formula not result
when excel doesn’t calculate a formula
When excel shows the formula instead of the result
Table of Contents
(0:00) Excel shows formula not result
(0:04) Cell formatted as Text
(0:23) in Show Formulas mode
Four answers today:
Excel remove duplicates without shifting
Keep Duplicates Remove Everything Else
Which Row does Excel Keep during Remove Duplicates
Excel Get Duplicates Back
Formula to Remove Duplicates in Excel using UNIQUE and SORT functions
FILTER to keep only certain columns
Ctrl+z or Alt+Backspace to Undo
Topics discussed in this video include:
excel remove duplicates without shifting
excel only include duplicates
excel keep duplicates remove unique
excel keep duplicates remove everything else
excel keep duplicates
excel duplicates keep
how to get duplicates back in excel
can you add duplicates back in excel
excel list duplicates between two columns
excel remove duplicates using formula
excel duplicates remove formula
excel duplicates formula
excel is duplicate formula
in excel duplicate formula
excel no duplicates formula
excel Continue reading “Excel KEEP Duplicates Delete Everything Else – 2513”
Error Bars help visualize any uncertainty present in your data. Uncertainty is an important aspect to data or any fields so it’s best not to shy away from it. In this tutorial, Federico shares a couple of tricks with the Error Bars and how you can use it specify upper and lower bounds to the values in your line chart and customize the way the uncertainty is visualized on your Power BI reports.
***** Video Details *****
00:00 Introduction
01:36 Format pane
01:55 Error Bars
03:43 Different applications of Error Bars
***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – Continue reading “How To Utilize Error Bars In Power BI To Visualize Uncertainty In Your Data”
The base tooltips in Power BI are fine. But are you overusing them? Adding everything to them in your visuals? Adam gives you some things to think about with your tooltips!
Create tooltips based on report pages
https://docs.microsoft.com/power-bi/create-reports/desktop-tooltips?tabs=powerbi-desktop
📢 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!
*******************
— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— <a href="https://guyinacube.com" Continue reading “Are you thinking about your tooltips in Power BI?”
5 Excel topics in 55 seconds. In this video, I answer five common questions about duplicates in Excel. This video will address:
excel find duplicates without deleting
can excel find duplicates
excel duplicates find
can i find duplicates in excel
excel remove duplicates without losing data
excel find duplicates in a list
can excel highlight duplicates
excel duplicates highlight
can excel look for duplicates
can excel pick up duplicates
excel recognize duplicates
how to see if duplicates in excel
how to see duplicates in excel column
excel check for duplicates in a list
excel duplicate check
excel check if duplicates in range
excel for duplicates
excel duplicates in one column
excel duplicates color
excel and duplicates
excel duplicates conditional formatting
excel duplicate Continue reading “Excel Duplicates – 5 Answers in 55 Seconds – #shorts”
In this tutorial, Sam demonstrates how to use DAX measures to work out the difference between calculated amounts this year versus last year. Get an intro into the concept of measure branching in DAX.
***** Video Details *****
00:24 Summing up revenue column
00:37 Total sales measure
01:46 Reviewing total sales information by date
02:34 Total sales last year
04:20 Difference between sales this year vs last year
05:42 Visualization of difference between sales this year vs last year
***** 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 Continue reading “Calculate Difference This Year vs Last Year In Power BI With DAX [2022 Update]”
Mohammad asks: How do we vlookup part of a cell in part of another cell. For example, find “bank of america” in “you have received money from bank of america account”. This video shows how to solve this with VLOOKUP, XLOOKUP, and SUMIFS.
Topics here:
wildcard excel lookup
wildcards in excel formula
how to use excel wildcards
excel how to search wildcards
what are excel wildcards
wildcards excel search
excel wildcard search in formula
excel wildcard search not working
excel wildcards search
microsoft excel wildcards
microsoft excel wildcard in formula
wildcard not working excel
excel wildcards does not work
excel using wildcards
excel wildcard for text
excel wildcards vlookup
excel wildcard xlookup
excel wildcard zero or more characters
excel wildcard Continue reading “Wildcards in Excel VLOOKUP XLOOKUP and SUMIFS – 2512”
Why Excel SUM is zero.
Why Excel Sum function not working.
Why Excel SUM returns 0.
Why Excel Sum is wrong.
Why Excel Sum shows 0.
Why Excel Not Showing Sum.
Why Excel Sum Formula Not working.
Do you have a column of numbers that won’t sum in Excel? It is most likely that the numbers have been stored as text. Here are two quick ways to convert those text numbers and the numbers will then sum.
One frustrating behavior when this happens: =SUM(A2:A4) is zero, but =A2+A3+A4 calculates correctly. That is because the plus sign coerces a number out of the text, but the SUM function is Continue reading “Why Excel SUM is Zero #Shorts”
Wondering how you can take advantage of the Formatted Tables feature in Power BI and automate the output to email? Jason Himmelstein shows you how you can do this with Power Automate!
Connect with Jason:
https://twitter.com/jasehimm
https://www.linkedin.com/in/jasonhimmelstein/
https://bifocal.show/
Formatted Tables:
https://docs.microsoft.com/en-us/power-bi/paginated-reports/paginated-formatted-table
Social hour at Power Platform Conference:
https://link.bifocal.show/socialhour
Power Platform Conference
https://powerplatformconf.com/
📢 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 “Automating your formatted tables in Power BI!”
Vineela is testing if two cells are the same with =IF(A2=B2. Both cells look exactly the same, but Excel is saying they don’t match! How to find why they don’t match.
Table of Contents
(0:00) Cells look alike
(0:20) =A2=B2
(0:33) Leading spaces
(0:45) F2 for trailing spaces
(1:20) Length & each character
(2:18) MID & ROW
(2:50) Five new books
(2:59) Get ASCII CODE
(3:20) Non-Breaking Space 160
(3:52) Formula to Fix
(4:50) Wrap-up
In this video, Melissa takes a closer look at the each-expression in the Power Query / M Language. When you see “each”, the formula or expression after it will be applied to each item in a list or column. Learn how you can utilize each in your reports.
***** Video Details *****
00:00 Introduction
01:25 Source
01:32 FunctionExpression
01:55 FunctionExpression2
02:07 EachExpression
02:16 EachExpression2
02:26 AllRows
***** 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
FREE – Power BI Resources – http://www.enterprisedna.co/power-bi-resources
FREE Continue reading “The Each Expression In Power Query / M”
Using Google Search autocomplete, today’s question… Is Excel Infinite?