Month: February 2022

image-2

How to Create a Measures Table (Placeholder for Measures) in Power BI

Posted on by Summa Lai

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

image-2

How to Fix “Microsoft Excel is waiting for another application to complete an OLE action”

Posted on by Summa Lai

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

image-2

How to Send or Save Large Attachments in Google Drive

Posted on by Summa Lai

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

image-2

How to Compare Sales With Last Year on Day in Week in Power BI

Posted on by Summa Lai

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