computaz

In the healthcare field, it is often desireable to identify a cohort of patients with similar, multiple diagnoses. This quick measure returns a comma-delimited list of patients that have all been identified with the same diagnoses. The tricky part here is that this allows the user to select from a s...

In the April 2023 release of Power BI Desktop, two new functions, RANK and ROWNUMBER, have been added to the DAX window functions family, along with significant enhancements to the ORDERBY sub-func…

Publish your Excel workbook as a web-app dashboard. Episode recap: Before going to the web, make your dashboard look less like Excel Select all cells and apply a light fill color to get rid of the gridlines. On the View tab, uncheck Formula Bar, Headings, and Gridlines. At the right edge of the ribbon, use the ^ to collapse the Ribbon. Use the arrow keys to move the active cell so it is hidden behind a chart or slicer. Hide all sheets except for the dashboard sheet. I use Custom Views so I can later Unhide All Worksheets In Excel Options, Advanced, you can hide the scrollbars and sheet tabs. Create a range name around your dashboard File, Info, Browser View Options (used to be File, Export) Save to the One Drive Get a sharing link

How to create interactive check boxes in Excel, which can be linked to formulas, charts, conditional formatting and other features. Check boxes can be a great way to make your spreadsheets more visually appealing, user-friendly and efficient, allowing users to quickly select options and see the results of their selections in real-time. We'll walk you through the process step-by-step. 🔻 DOWNLOAD EXCEL FILE HERE: https://www.myonlinetraininghub.com/interactive-excel-check-boxes 🎓 LEARN MORE in my Excel courses: https://www.myonlinetraininghub.com/ 🔔 SUBSCRIBE if you’d like more tips and tutorials like this. 💬 Please leave me a COMMENT. I read them all! 🧟‍♀️ CONNECT with Mynda on LinkedIn: https://www.linkedin.com/in/myndatreacy/ 🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍 💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/excel-forum ⏲ TIMESTAMPS 0:00 Introduction 0:48 Check Box Task List 3:02 Status Bar Linked to Task List 4:48 IF formula linked to Check Box 6:37 Conditonal Formatting linked to Check Boxes 9:58 Charts Linked to Check Boxes

Nothing impresses your audience more than moving data from a table to a map.Learn how to do it easily with Excel & Power BI.👉 Sign up for 13 hours of FREE E...

Smoothing data using local regression

Toptal Utilities is a collection of helpful tools and resources for online professionals curated and created by our community. Get started for free now.

Embedding dashboards and reports in web pages is super easy when your files are saved on OneDrive or SharePoint. Get the step by step written instructions here: https://www.myonlinetraininghub.com/embedding-excel-dashboards-in-a-web-page View my comprehensive courses: https://www.myonlinetraininghub.com/ Connect with me on LinkedIn: https://www.linkedin.com/in/myndatreacy/ 0:00 Introduction 0:41 Defining a Named Range 1:09 Getting embed code from OneDrive/SharePoint 4:43 Web Page demo 5:44 Things to avoid 6:25 Getting iframe embed code from OneDrive Personal 11:04 Getting JavaScript embed code from OneDrive Personal 12:15 Limitations

We had a question about how to get a clock in Power BI? Is that even possible? Patrick takes advantage of the Deneb visual to make it happen! Vega Clock Sample https://vega.github.io/vega/examples/clock/ HTML Content Custom Visual Limitations https://www.html-content.com/reference/limitations Kerry Kolosko https://kerrykolosko.com/exploring-deneb-for-power-bi/ 📢 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/ -- https://guyinacube.com ***Gear*** 🛠 Check out my Tools page - https://guyinacube.com/tools/ #PowerBI #Deneb #GuyInACube

In this blog, we're going to go over how you can create automated forecast from historic data in Power BI using time intelligence and cumulative totals.

Remove accents and other diacritics from text in Power Query by converting the text to a binary using the Greek code page and converting back

Interactive checklists & guides for all Power BI content types, with links to reference content & documentation.

1. In Power BI, choose Get Data In a new Power BI file, select “Get Data” to get a list…

★ Want to automate Excel? Check out our training academy ★ https://exceloffthegrid.com/academy ★ Check out the blog post ★ https://exceloffthegrid.com/using-slicers-with-formulas/ ★ About this video ★ Slicers are an excellent tool for adding interactivity. When a user clicks on a slicer button, the results change to include only those selected items. Slicers are compatible with PivotTables, PivotCharts, Cube formulas, and Tables…but not standard formulas. So, let’s see how we can use a Table in a new way to get around this limitation. 0:00 Introduction 0:37 Creating the slicer 1:53 Count visible rows with SUBTOTAL 3:52 Connecting the Slicer to the formula 6:06 Using a LAMBDA function 9:16 Conclusion ★ Download 30 most useful Excel VBA Macros ebook for FREE ★ https://exceloffthegrid.com/ ★ Where to find Excel Off The Grid ★ Blog: https://exceloffthegrid.com Twitter: https://twitter.com/exceloffthegrid #MsExcel #PowerQuery

Power Query can connect to a web page and get data from there, and I have explained it before in my article about movies data analysis. However, the default way of getting data from the web page doesn’t fetch images into your report. Images in a webpage come through their own URL. If you can Read more about Get Images from Web Page Into the Power BI Report Using Power Query[…]

Learn how to use structured refernces to make running totals in your Excel Tables. You can also make the running totals conditional on specific creteria.

The tutorial shows how to do multiple criteria vlookup with INDEX and MATCH in Excel. Formula examples are available for download.

Create grouped running totals with a Power Query custom function. Simple to use and extremely fast. Example workbook with code to download.

My journey with Deneb, a Power BI custom visual

OUTLINE Introduction: What is Sentiment Analysis? Use Case: Twitter Data Aim of the project Tools used and workflow Data Gathering Data Wrangling/Preprocessing Sentiment Analysis Visualization   Introduction As a data analyst, there will be scenarios where your data will come from secondary sou...

Join 300,000+ professionals in our courses: https://www.xelplus.com/courses/ In this video I'll cover the 10 best, free add-ins for Microsoft Excel. Tools to easily embed mind maps or shopfloor layouts, an Excel calendar date picker, a free Excel add-in to get free data, translate Excel function names, create your custom Lambda function, add QR codes to Excel, automate Excel to Word file creation, create cool Excel map charts and many more. 🌍 My Online Courses ► https://www.xelplus.com/courses/ 00:00 The 10 Best Free Excel Add Ins 00:22 How to Install an Add-In 00:39 Wikipedia 01:37 FRED - Economic Data 02:45 Mini Calendar - Date Picker 04:21 Excel Functions Translator 05:40 Symbols and Characters 06:33 QR4Office - Transform Links to QR Codes 07:02 draw.io - Diagrams 08:10 Bing Maps - Visualize Your Data 08:57 Advanced Formula Environment 10:46 Excel-to-Word - Automate Content 11:52 How to Uninstall Add-Ins 12:34 Wrap Up 🎬 LINKS to related videos: 5 FREE Cool Add-Ins for PowerPoint to Start Using NOW: https://youtu.be/ssbBaYLq8Mg 6 FREE Add-Ins for Excel to Start Using Now: https://youtu.be/nXGPz1ETzWI 👕☕ 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 #addins

Evaluation context is the most important concept to understand in DAX . This context is used when evaluating expressions to get to the result.

Using List functions in Power Query to do Exact Lookup and Approximate Match Lookup is faster and easier to create than using table merges.Download the Excel...

Embedding Excel Dashboards in a Web Page from files on SharePoint or OneDrive for Business or OneDrive Personal.

Below I explain how to do this. The solution is super straight forward and does not have anything to do with publishing a chart.

Are you looking for the best Power BI learning resources but don't know where to start? Wondering where to find quality resources, the top blogs or where you

The Yahoo Finance API is a range of libraries/APIs/methods to obtain historical and real time data for a variety of financial markets and products.