computaz

In this article we talk about how to handle different granularities in Power BI showing various options such as data modeling and DAX techniques.

space-gray like color palette created by seldon that consists #343d46,#4f5b66,#65737e,#a7adba,#c0c5ce colors.

This blog post is to document my first experience with mapping in PowerBI, usually the reports we produce are time series and pivot tables, but in this case, there is a geographic dimension to the …

For this video, I’d like to go through a custom visual I used in the report I developed for my eDNA Power BI Challenge 16 entry that’s called a KPI ticker. I...

This is how to use the New Card Visual in Power BI (June 2023 Update)=================================🔥June 2023 PowerBI Update : https://www.microsoft.com/...

Learn how to use Tweet threads so you can tell your brand story in more than 280 characters. We've got tips and examples for best practice.

ClickUp comes with hundreds of powerful productivity features that can be customized for any work need — with more added every week. Try ClickUp Free Forever today!

Excel VBA personal formula to calculate Haversine with optional radius paramether

Robly is a leading innovator in Small Business Marketing Automation. Robly invented OpenGen in 2014 and Robly A.I. in 2015.

Learn how to easily compare 3 or more tables in Power Query and avoid having to do lots of complicated query merges.0:33 Power Query Lists (Table Columns)1:0...

This video shows how to create an index column for each category in your table. Within each category the number then starts from 1 and increases sequentially...

Learn how to Select a measure using a slicer in Excel Power Pivot and Dax. Dynamic selection of measures using a slicer enables your users to analyze multipl...

I need to capture the selected value of a slicer like ID or Date. In browsing the Slicer Settings, there a defined name for the Slicer and stated that its can be used in a formula. I tried to in insert in a cell =INDERECT formula or simply =defined name but none did work.  Is there a way to get the ...

Returns true when there are direct filters on the specified column.

Tips and Tricks for Power BI Map visualizations, visuals, locations, longitude and latitude, and how they work with Bing Maps.

Use Excel Power Query to get all text combinations.

This post looks at how to structure your Power Query setup to avoid the "please rebuild this data combination error" when you try to merge two queries.

Master IF Statements in Power Query! Explore IF functions, syntax, conditional logic, error handling, and advanced techniques.

Nocodelytics is the easiest way to track CMS engagement on your Webflow site. Simple no-code setup.

This article shows how to get the previous row value using Power Query. You can adjust the 3 ways to also retrieve an earlier or later row.

Join 300,000+ professionals in our courses: https://www.xelplus.com/courses/ The FILTER function in Microsoft Excel allows you to filter a range of data based on criteria. This criteria applies to a single column. But what if you need to use the Excel Filter function and apply a condition that applies to multiple columns? You might need to include two or more columns. You might need to account for AND conditions - i.e. the criteria applies to each column, or you might need an OR condition: the criteria applies to either column. There is a trick you can use with the FILTER function that helps you account for multiple columns easily. Once you learn how Excel calculates the FILTER function in the background, you'll learn how to account for any condition, value or criteria you need. Learning this will make you an Advanced Filter functions specialist :). I'll also show you the new way of using the FILTER function and returning only the columns you need: Combine FILTER with the CHOOSECOLS function to return only the columns you need. 🌍 My Online Courses ► https://www.xelplus.com/courses/ 00:00 Using Multiple Criteria within the Excel FILTER Function 00:41 Multiple Criteria With AND 04:58 Multiple Criteria With OR 05:51 FILTER function to return specific columns with CHOOSECOLS 07:09 FILTER Multiple Criteria In The Same Column 09:19 Wrap Up 🎬 LINKS to related videos: Excel Lookup to Return Multiple Values with FILTER Function: https://youtu.be/Eehk6PC0oGs 👕☕ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/ 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/ 📚 Excel RESOURCES I Recommend: https://www.xelplus.com/resources/ 🎥 GEAR I use: https://www.xelplus.com/resources/#gear More resources on my Amazon page: https://www.amazon.com/shop/leilagharani 🚩Let’s connect on social: Instagram: https://www.instagram.com/lgharani Twitter: https://twitter.com/leilagharani LinkedIn: https://at.linkedin.com/in/leilagharani 👉 This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support! #Excel

Excel check boxes are interactive elements you can link to formulas, charts, conditional formatting and more.

Do you want to create a single slicer containing the values from different columns?Learn how to create a slicer that applies the selected filters on any of t...

Learn how to create and use Power BI Slicer with multiple columns, how to work with Power BI slicer format multiple columns, and so on.