power bi desktop
418 TopicsDAX Support with Dates and averages
I am still a novice with DAX. I am trying to get a measure that responses to the date slicer. I have a task tracker that has a task open date and task closed date. All open and closed tasks are in the same SharePoint list I would like to get the average days to close each closed tasks. I've tried filter and I've tried CALCULATE but I cannot get the right syntax. Can someone get me started?Solved80Views0likes6CommentsPower BI DAX Financial Functions Explained | RATE, INTRATE & RECEIVED
In this video, you'll learn three important Financial DAX Functions in Power BI with practical business examples and step-by-step demonstrations. ✅ RATE Function – Calculate interest rates for loans and annuities ✅ INTRATE Function – Determine the interest rate earned on fully invested securities ✅ RECEIVED Function – Calculate the maturity value received from discounted securities watch?v=WDwYz-oGcV4?si=7sO1r1A0F9y05Rz4134Views6likes4CommentsTBILLPRICE, TBILLYIELD & TBILLEQ in Power BI DAX | Financial DAX Functions Explained
In this video, you'll learn three important Financial DAX Functions in Power BI: ✅ TBILLPRICE ✅ TBILLYIELD ✅ TBILLEQ Using practical business and finance scenarios, I explain how these functions help calculate Treasury Bill prices, yields, and bond-equivalent yields directly within Power BI. Whether you're a Power BI Developer, Data Analyst, Financial Analyst, or someone preparing for Microsoft Power BI interviews, this tutorial will help you understand these financial functions with ease.82Views6likes4CommentsPower BI Financial DAX Functions Explained | ODDFPRICE, ODDFYIELD, ODDLPRICE & ODDLYIELD
In this video, you'll learn four advanced Financial DAX Functions with practical, real-time business examples. ✅ ODDFPRICE ✅ ODDFYIELD ✅ ODDLPRICE ✅ ODDLYIELD If you find this video helpful, please Like, Share, and Subscribe to the NDAC Channel for more learning content.30Views0likes0CommentsMDURATION, PDURATION & NPER in DAX | Financial Functions with Real-Time Examples
In this Power BI DAX tutorial, learn how to use MDURATION, PDURATION, and NPER financial functions with practical real-world examples. Whether you're preparing for Power BI interviews, working in financial analytics, or improving your DAX skills, this video will help you understand these advanced financial DAX functions clearly. Subscribe for more Power BI, DAX, Microsoft Fabric, Data Analytics, and Business Intelligence tutorials.88Views4likes5CommentsClaude Built My Power BI Dashboard. Here's how.
I sketched a rough wireframe of a dashboard I wanted—no DAX, no data model, just a layout idea. Then I handed it to Claude AI connected to Power BI Desktop through MCP and watched it build the actual dashboard: creating the semantic model, writing every measure from scratch, and turning a static sketch into a working, interactive report. This is the wireframe-to-dashboard workflow in full — how Claude reads a visual mockup, maps it to real fields and calculations, and produces DAX measures on its own without me writing a single line.84Views0likes0CommentsStop Documenting Power BI Manually: 5 Claude AI Hacks
Claude AI + Power BI (via MCP) Claude AI can now: Read your Power BI semantic model Audit your DAX Create new measures Query your data live ⚡ In this video: the 5 highest‑value things to do right after connecting Claude to Power BI, demonstrated on a real, messy, production‑style model. You’ll see Claude: Auto‑document an entire model in ~90 seconds Catch real DAX errors (divide‑by‑zero, duplicated measures) Write and insert a Sales YoY Growth % measure with proper blank‑handling Answer data questions with live DAX queries—no visuals needed Flag relationship problems that silently produce wrong results 👉 Which one are you trying first? watch?v=V-1er3Q_lrQ353Views0likes2CommentsHybrid Tables in Power BI | Shabnam Watson
Hybrid Tables in Power BI Hybrid tables, a new addition to Power BI, are a game changer in that they provide the best of both worlds by allowing one table to have two storage modes at the same time! Before the introduction of Hybrid tables, each table in Power BI could only have one storage mode: Import which loaded data entirely into Power BI’s memory or DirectQuery which left data in the back-end data source. When working with near real time requirements, Power BI developers had to use tables with DirectQuery; however, DirectQuery by itself could result in less than optimum query performance for large datasets and put a burden on the backend system. Hybrid tables combine the two storage modes and therefore provide improved query performance for historical data by loading them into memory (Import) and provide near real time capability for recent data (DirectQuery). Join this session to learn about different table storage modes in Power BI including the newest Hybrid option and how to use it. Agenda: Introductions (5 mins) Presentation (55 mins) Q&A session (15 mins) About Shabnam Watson: Shabnam Watson is a Business Intelligence consultant and Microsoft Data Platform MVP with 20 years of experience developing Data Warehouse and Business Intelligence solutions. She has worked across several industries including Supply Chain, Finance, Retail, Insurance, and Health Care. Her areas of interest include Power BI, Analysis Services, Performance Tuning, PowerShell, DevOps, Azure, Natural Language Processing, and AI. Her work focus within the Microsoft BI Stack has been on Analysis Services and Power BI. She is a regular speaker and volunteer at national and local user groups and conferences. She holds a bachelor’s degree in Computer Engineering, a master’s degree in Computer Science, and a Certified Business Intelligence Professional (CBIP) certification by The Data Warehouse Institute (TDWI). This event is online. You may need to install Zoom: https://zoom.us/download Space is limited so reserve your seat. Contact with Shabnam: LinkedIn: https://www.linkedin.com/in/shabnamwatson/ www: https://shabnamwatson.wpcomstaging.com/ Twitter: shbwatson Members participating in Meetup Live events must be respectful in interactions with people and in content posted on the platform.1.3KViews0likes0CommentsPython For Power BI Developers
As a Power BI developer you write DAX, M but should you learn Python as well? While there are limited use cases for using Python directly in Power BI, in this session Sandeep will show you how you can use Power BI in your development workflow. He will show how you use can use Python for analyzing Power BI datasets, debug DAX, find insights faster, and even for Power BI administration. As lakehouse architecture patterns become common you should strongly consider adding Python to your tool chest. Sandeep will also share resources to learn Python for data analysis. **No prior Python experience is required to attend this session. 𝙋𝙚𝙧𝙨𝙞𝙖𝙣 𝙋𝘽𝙄𝙐𝙂- 𝙈𝙞𝙘𝙧𝙤𝙨𝙤𝙛𝙩 𝘾𝙤𝙢𝙢𝙪𝙣𝙞𝙩𝙮: https://bit.ly/3IAg7xT 𝙇𝙞𝙣𝙠𝙚𝙙𝙄𝙣: https://bit.ly/32tGkif 𝙏𝙚𝙡𝙚𝙜𝙧𝙖𝙢 𝘾𝙝𝙖𝙣𝙣𝙚𝙡: https://t.me/PersianPBIUG 𝙔𝙤𝙪𝙏𝙪𝙗𝙚: https://bit.ly/3hk20RL Language: English310Views0likes0CommentsDAXdakan ep4: PBI Desktop Nov 2023 Update
As requested, let's discuss the November 2023 update of Power BI. Button slicers and Copilot! DAXdakan is a fortnightly Teams meeting with other Power BI-erists (Power BI Pilipinas members). Language is Filipino/English. Attendance is free.225Views0likes0Comments