Join the Fabric Partner Community for this Week's Fabric Engineering Connection!
Are you a Microsoft partner thatis interested in data and analytics? Be sure to join us for the final Fabric Engineering Connection of 2024! We will feature presentations from Maya Shenhav on Power BI Mobile and Matthew Hicks on Shortcuts to Iceberg Tables. Plus, join us early, from 7:45-8 am PT, for some holly jolly fun with our holiday-themed trivia contest! 🎅 🎄 This is your opportunity to learn more, ask questions, and provide feedback. To join the call, you must be a member of the Fabric Partner Community Teams channel. To join, complete the participation form at https://aka.ms/JoinFabricPartnerCommunity. We can't wait to see you Wednesday!
Dax measure not considering the filter context and not aggregating
Hi, I have the below visual and highlighted Dax is having problem: Below is Dax: noofdays = COUNTROWS(Calendar_) For the below selected filters, noofdays dax should display 60 for month of September 2024 and 62 for month of October 2024. The total aggregate value should be 122 days. But this dax is giving wrong values now. FYI, when I bring in DBName-Points_Id into the visual,it is giving correct values row by row but when removed it doesn't: FYR, My expected output should be like below: PFA file here Portfolio Performance - v2.15 (1).pbix Please let me know if you need further info! Thanks in advance! SergeiBaklanJoin the Fabric Partner Community for this Week's Fabric Engineering Connection!
Join us this Wednesday, December 11, from 8-9 AM PST for the weekly partner community call, Fabric Engineering Connection!This week's call will feature presentations on Open Mirroring from Mark Pryce-Maher and Copilot for Power BI from Lada Hill. The Fabric Engineering Connection is a weekly call held in the Fabric Partner Community Teams Channel exclusively for partners. Hear directly from Fabric product engineering teams about upcoming features, ask questions, and provide feedback. To join these calls (as well as watch recordings of previous calls), please join the Fabric Partner Community Teams Channel by completing the participation form athttps://aka.ms/JoinFabricPartnerCommunity.
Downloading multiple files from excel hyperlinks
Dear experts, Could you please share any Excel formula or PQ solution to download multiple files from excel hyperlinks. Each cell have one hyperlink and there are total > 100 hyperlinks, it's difficult to download each file one-by-one. Thanks in Advance, Br, AnupamPower Automate/Query Assistance - Add new table in file to bottom of existing/trend assistance
Forgive me if this has been answered elsewhere, I have had a look and not been able to find! Essentially, I have set up a flow using Power Automate that saves an XL I receive via a scheduled email into a sharepoint location. I have then created an excel document that queries this file in order for me to maintain a daily report. My issue is this. I am currently trending the data, but the only way I have of doing this is by copy and paste into a separate sheet (adding to the bottom of the previous data each day/week (select timescale) manually) as the data gets overwritten on each data refresh. I'm sure there is, but is there a way via either macro or power automate of me automating this process so that each day the table in the new file is just added to the bottom of the existing?? Thanks in advanceAutomating Party Transactions in Excel Using VLOOKUP and VBA Macros or anything
Hi everyone, I have a main sheet named "DAILY INWARD OUTWARD" that contains transactions for over 50 parties. Each party does multiple transactions, and I need to manage their stocks. Currently, I manually create separate sheets for each party and record their transactions, which is time-consuming. See this is my master sheet and I make stocks like this That month Jodhka made 4 transactions, so by searching in master sheet all over made manually my diff party list. likewise i have to maintain 100+ party details, so anyone can help me reagarding this? I would like to automate this process using VLOOKUP and VBA macros or anything. Specifically, I need help with: Using VLOOKUP to fetch transactions from the main sheet to individual party sheets. Writing a VBA macro to create separate sheets for each party and copy their transactions from the main sheet. Any guidance or examples on how to achieve this would be greatly appreciated. Thank you!
