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
How to Apply Many-Many Relationships in Power BI Desktop
With relationships with a many-many cardinality in Power BI Desktop, you can join tables that use a cardinality of many-to-many. You can more easily and intuitively create data models that contain two or more data sources. Relationships with a many-many cardinality are part of the larger composite models capabilities in Power BI Desktop. A relationship with a many-many cardinality in Power BI Desktop is Read More
How to Use a Measure to Filter a Power BI Visualization
Every visualization in Power BI has a Visual Level Filters section that by default includes all the columns and measures included in the visualization. This section can include additional filters over columns and measures. The Visual Level Filters section is the only one accepting a measure as a filter, whereas Page Level Filters and Report Read More
How to Use Date vs Date Hierarchy in Power BI
By Steve Young As with most data analysis tasks, working with time can be the most challenging detail to get correct. Power BI has built-in functionality that will display a drillable hierarchy of year, quarter, month and days when a column, formatted as a date, is dropped onto a visualization. This feature can be handy Read More
Best Business Password Managers : From Enterprises to Teams and SMBs
By Darcy French Protect your business with password management software The best business password management software make it simpler and easier to manage employee passwords in a secure way. This is important, as the increasing number of passwords and online protections against fraud and malware attack means a password management solution is becoming a must-have for Read More