Creating a measures table in your Power BI data model is one of the most common questions we get from folks wondering how they can better organize the measures they create. When navigating through your data model in Power BI Desktop, it’s easy to get lost in a sea of tables and fields, especially if Read More
Month: February 2022
How to Fix “Microsoft Excel is waiting for another application to complete an OLE action”
1st troubleshooting 1. Open the Excel sheet and go the File menu. In the File menu, click on Options. 2. An Excel Options dialog box will appear. Go to the Advanced tab and scroll down to the General area. Over there check Ignore other applications that use Dynamic Data Exchange (DDE). 3. Restart Excel. 2nd troubleshooting, if you are using Google Drive Google Drive Read More
How to Send or Save Large Attachments in Google Drive
When you’re sending a file, you can add attachments in Gmail up to 25 MB—but what if you have larger files such as videos? Save these large files in Google Drive, then insert a link to the Drive or shared drive file in your email. Note: If your recipients don’t have viewing permissions for the file, you Read More
How to Compare Sales With Last Year on Day in Week in Power BI
A very normal calculation we do is to compare a value, for example, sales, against how we did last year. The easiest way to do this is by using the SAMEPERIODLASTYEAR function to create a measure that looks like this Sales LY = CALCULATE( [Sales] ,SAMEPERIODLASTYEAR(DimDate[Date]) ) As shown in the image above this works Read More
How to Calculate Weekly Average with DAX Formulas
Backgrounds A bit of context – I have a dataset with a date table and a table which is a list of ‘Tickets issued’. They are linked via Issued Date. I am trying to get the average number of tickets Issued a week, for each location (tickets have the location that they were issued to). Read More
Azure Data Studio vs SSMS
For 15 years, SSMS has held the title of the top SQL Server database tool. That’s no easy feat, especially in the software world, where things can change faster than you say “blueberry pie.” But then a contender emerged, developed and released by the same Microsoft folks in 2018. It was Azure Data Studio – Read More