Excel Date Picker
Hello , I would like to add date picker on an excel sheet. The goal is to create an excel file and have this sent to users to fill in. When filling the excel, and click on the start date, a calendar dropdown should appear and users select the date from the calendar so as to eliminate different date format and make it unique across the document. I was able to get a date picker add-in however this wont work because I am sending to users please see below:Building a Gantt Chart using Power BI
Few weeks ago, I was tasked to build a Gantt chart, but I didn’t have a clue on how to do it. So, I did it the “Old fashion way” using excel sheet and adding all the adjustments manually i.e., colors, timeline, dates and tasks. I completed the task, but I felt there was a way around it and that was when I discovered a visualization on Power BI where you can build a Gantt chart is just a matter of minutes. Let’s breakdown the step-by-step process to achieve this. Don’t worry if this is new to you🙂. Let’s get to the introduction.
We Found Extra Characters at End of JSON Line
Using the JSON files provided on the Yelp website, https://www.yelp.com/dataset. When attempting to connect to the files via Excel's "Get Data" or Power BI, and error message appears stating "We found extra characters at end of JSON line." Attached is a sample of the data. Any ideas why the error message is being returned? Thank you in advance!Create custom reports using Microsoft Defender ATP APIs and Power BI
Typical enterprise security operation teams often rely on dependable reporting visualisations to make critical security decisions. While Microsoft Defender ATP provides extensive visibility on the security posture of your organization through built-in dashboards, custom reporting can help you turn security data from multiple sources into insights to meet your analytical needs.
IF statement based on multiple columns.
Vendor 1 Vendor 2 Vendor 3 Vendor Master ABC BCD CDE Hi everyone, I'm trying to put up a IF formula for the following scenario. But I'm facing difficulty in getting the proper solution. It would be great if someone would help me to build a proper formula for this one. Problem statement: I have 3 columns for Vendors i.e Vendor 1, Vendor 2, Vendor 3. I want to put up a formula in "Vendor Master" such that IF "Vendor 1" is blank then it should return value from "Vendor 2" in "Master Vendor". IF "Vendor 2" is also blank then it should return value from "Vendor 3". IF "Vendor 3" is blank then it should return a string "No Vendor". It would also be great if someone could tell me how this can be done in Power BI as well. Quick response is highly appreciated. Thanks in advance.
Auto refresh excel sheet without opening excel files
I am trying to refresh the contents on the excel web version automatically without opening the excel file I am using the TODAY() function in an excel worksheet which is accessed using PowerBuilder. Now I have to open the excel file just to update the TODAY() function, and this method is a bottleneck in my workflow.I want the contents to reflect on the power builder without opening the excel file.I cannot use VBA macros as excel web doesn't support that
