Summary The Excel EDATE function returns a date on the same day of the month, n months in the past or future. You can use EDATE to calculate expiration dates, maturity dates, and other due dates. Use a positive value for months to get a date in the future, and a negative value for dates Read More
Month: June 2021
Which Is Better? Power BI Vs. Tableau
In the search for data visualisation or business intelligence tool, we have two options to adopt; they are nothing but Power BI and Tableau. Both products are very similar to each other. Now it’s time for us to look at which is better. Power BI Vs. Tableau: A Useful Comparison We can choose the best Read More
Understand DAX operators in Power BI
The Data Analysis Expression (DAX) language uses operators to create expressions that compare values, perform arithmetic calculations, or work with strings. Types of operators There are four different types of calculation operators: arithmetic, comparison, text concatenation, and logical. Arithmetic operators To perform basic mathematical operations such as addition, subtraction, or multiplication; combine numbers; and produce Read More
Understand “Analyze in Excel” in Power BI
With Analyze in Excel, you can bring Power BI datasets into Excel, and then view and interact with them using PivotTables, charts, slicers, and other Excel features. To use Analyze in Excel you must first download the feature from Power BI, install it, and then select one or more datasets to use in Excel. This article shows you Read More
How to Solve DAX Time Zone Issue in Power BI
Power BI is a cloud service, and that means Power BI files are hosted somewhere. Some DAX functions such as Date/Time functions work on system date/time on the server their file is hosted on. So If you use DAX functions such as TODAY() or NOW() you will not get your local date/time, You will fetch Read More
How to use Delete Method of Worksheet Object in Excel VBA
Delete Worksheet method in VBA is used to delete the sheet from the Excel workbook. When we delete a worksheet, Delete worksheet method displays a dialog box that reminds the user to confirm the deletion by default. If we click on Delete button on the dialog box then it deletes the worksheet from a workbook. Read More