Excel Hash Sign (#) in Excel Formulas and Functions
In this article, we will learn about the Hash sign (#) you often see people use in some Excel functions and formulas. Requirements and availability You would need to have…
Delete MAXROWS 1000
How To Display More Than 1000 Rows in Excel for Power BI Datasets Pivot Table Value Double Click Drilldown
Here's an interesting thing people used to Excel standard Pivot Table find surprising when they create a Pivot Table off a Power BI dataset. The usual expectation when you double…
Connecting to Google BigQuery from Power BI Desktop
Big Data… Everyone is talking about it but what exactly is it? Big data refers to a large amount of data that is too large to be processed and analyzed…
Data Model and Table Relationships for a Required Report
Assuming you were already done with the import and cleaning of your dataset in Power Query. You can then proceed to the Model Tab and build the relationship between the…
Invitation: Join UrBizEdge Live Session with Microsoft HQ Excel Team Managers on New Features in Microsoft Excel
Microsoft is doing us a special honor. Three managers from the Excel team at Microsoft HQ are going to be guest presenters at our Dec 6, 2020 live meetup session.…