Les Black

In PowerBI, calculate attendance from a table which has missing data https://lnkd.in/gxexm7Kh #powerbidesktop #powerbi #datamodelling #dax #powerpivot #microsoftexcel #msexcel #excel

1

In PowerBI, calculate a measure on a subset of the table https://lnkd.in/gR88kDBP #powerbidesktop #powerbi #datamodelling #dax #powerpivot #microsoftexcel #msexcel #excel

2

In PowerBI, compute an average per group only when a specific item is available in the Category column https://lnkd.in/gADbgZqP #powerbidesktop #powerbi #datamodelling #dax #powerpivot #microsoftexcel #msexcel #excel

2

In PowerBI, calculate sales of the penultimate month https://lnkd.in/g-UrXEZd #powerbidesktop #powerbi #datamodelling #dax #powerpivot #microsoftexcel #msexcel #excel

4

In PowerBI, count the distinct ID's based on the latest status https://lnkd.in/g5F6ArhQ #powerbidesktop #powerbi #datamodelling #dax #powerpivot #microsoftexcel #msexcel #excel

1

In PowerBI, via a calculated column formula, generate dates based on a condition https://lnkd.in/gZagQ_rU #powerbidesktop #powerbi #datamodelling #dax #powerpivot #microsoftexcel #msexcel #excel

1

In PowerBI, via a calculated column, fetch the last version of software installed from another table https://lnkd.in/gx7Rtxhg #powerbidesktop #powerbi #datamodelling #dax #powerpivot #microsoftexcel #msexcel #excel

1

In PowerBI, calculate gender wise retention rate https://lnkd.in/g8PyDEGH #powerbidesktop #powerbi #datamodelling #dax #powerpivot #microsoftexcel #msexcel #excel

1

𝗠𝘆 𝗣𝗿𝗲𝘀𝗲𝗻𝘁𝗮𝘁𝗶𝗼𝗻 𝗶𝘀 𝗼𝗻 𝗬𝗼𝘂𝗧𝘂𝗯𝗲 That's right, Power BI & Fabric Manchester UG have given me a platform, so I'm going to shout about it. If you're interested in: - Incremental Refresh - The XMLA Endpoint - TMSL Scripts - Power BI's Advanced Partitioning capabilities Or, if you just want to find out how me and my thick Bristolian accent got on the first time I spoke in front of a crowd 𝗜 𝘀𝘂𝗴𝗴𝗲𝘀𝘁 𝘆𝗼𝘂 𝗳𝗼𝗹𝗹𝗼𝘄 𝘁𝗵𝗲 𝗹𝗶𝗻𝗸 𝗯𝗲𝗹𝗼𝘄. https://lnkd.in/eRTcxpkc * 𝘉𝘰𝘯𝘶𝘴 𝘱𝘰𝘪𝘯𝘵𝘴 𝘢𝘸𝘢𝘳𝘥𝘦𝘥 𝘵𝘰 𝘢𝘯𝘺𝘰𝘯𝘦 𝘵𝘩𝘢𝘵 𝘤𝘰𝘶𝘯𝘵𝘴 𝘵𝘩𝘦 𝘯𝘶𝘮𝘣𝘦𝘳 𝘰𝘧 𝘵𝘪𝘮𝘦𝘴 𝘐 𝘴𝘢𝘺 𝘱𝘢𝘳𝘵𝘪𝘵𝘪𝘰𝘯 𝘰𝘳 𝘱𝘢𝘳𝘵𝘪𝘵𝘪𝘰𝘯𝘪𝘯𝘨. ** 𝘛𝘩𝘢𝘵'𝘴 𝘯𝘰𝘵 𝘢 𝘮𝘰𝘶𝘴𝘦 𝘤𝘶𝘳𝘴𝘰𝘳 𝘮𝘰𝘷𝘪𝘯𝘨 𝘢𝘳𝘰𝘶𝘯𝘥 𝘵𝘩𝘦 𝘴𝘤𝘳𝘦𝘦𝘯, 𝘪𝘵'𝘴 𝘢 𝘥𝘪𝘨𝘪𝘵𝘢𝘭 𝘧𝘭𝘺.

17

9 Comments

Got some downtime on the work front in the next few weeks before the holidays roll into town? Why not squeeze in some free virtual #PowerBI training to finish out 2024 on a high note? We've got you covered. Reserve your seat for our last Power BI Dashboard in a day workshop of 2024 coming up on Friday, December 20th. It's FREE! Steve Mika will lead this workshop to help you polish up those dashboard design skills, upskill your data literacy, and bring your new knowledge to help evolve your organization. Maybe even get a raise? 🤔 No promises there, but what we can promise is a unique opportunity to get your hands on some real data sets and leverage your knowledge to build your own dashboard using Power BI. Did we mention it's FREE? Register here to reserve your spot: https://hubs.li/Q02-qhy10

4

Embarking on your DAX journey Understanding filter context is foundational... DAX functions operate within filter context by default, shaped by dimensions like 'Country,' 'Product,' or 'Date.' When a DAX measure is used in a visual, it leverages context (from dimension attributes) to provide insights to 'Total Sales.' The CALCULATE function stands out by its capacity to alter the initial filter context Mastering this default behavior of filter context will significantly enhance your ability to create powerful and informative DAX measures #LifelongLearning #OnlineEducation #DataScience #ContinuousImprovement #SkillDevelopment #PowerBI #Oman #Muscat #GCC #Training #Consulting

18

Switch before it hurts!🤕 That is the clear message our colleague Arto De Graef wrote in this latest #PowerBI blog. Lots of companies have done great without really paying too much attention to their data and its underlying processes. They have grown over time without doing so, but there is a risk in missing the next wave. Discover how Power BI will ease the switch and the vast amount of benefits this will bring to your reporting. If you aren't new to Power BI, check out our latest Webinar on Power BI + Copilot. That video is at the bottom of this blog. #PowerBI #ExcelReporting #ExcelToPowerBI

18

In PowerBI, show the count of active projects in a month https://lnkd.in/gfKYNXYg #powerbidesktop #powerbi #datamodelling #dax #powerpivot #microsoftexcel #msexcel #excel

1