Microsoft Excel’s TEXT function can help you to convert a date to its corresponding month name or weekday name easily. TEXT(A2,”dddd”) TEXT(A2,”ddd”) TEXT(A2,”mmmm”) TEXT(A2,”mmm”) In a blank cell, please enter this formula =TEXT(A2,”mmmm”), in this case in cell C2. , and press the Enter key. And then drag this cell’s AutoFill handle to the range as you need. And the Read More
Rogers Wireless Phones: How to Use Call Forwarding
The following steps explain how to use the Call Forwarding feature on your mobile device. Note: Conditional forwarding will not work when voicemail is activated. Change Settings: To change the existing or the active number of Call Forwarding: Cancel the existing Call Forwarding. Reactivate Call Forwarding with a new phone number. Call Forwarding types: Unconditional Type Read More
Understanding Difference Between Calculated Columns and Measures in Power BI
Calculated columns When you create a data model in Power Pivot for Excel, Analysis Services Tabular, or Power BI Desktop, you can extend a table by creating new columns. The content of the columns is defined by a DAX expression evaluated row by row. The user interface is different depending on the tools you use. Read More
How to Change Power BI Data Source From MS SQL Server to Excel
Changing Power BI data source from MS SQL Server to Excel for Power BI file
5 Best Cloud Databases
1, Amazon DynamoDB,2, Google BigQuery,3, Azure SQL Server,4, Azure Cosmos DB,5, Amazon Redshift In 2012, Amazon released the first cloud database DynamoDB and changed the database landscape forever. Since then, cloud databases have experienced a meteoric rise in terms of adoption and innovation. As the whole Software development industry moves towards cloud-native development, cloud databases Read More
About using DirectQuery in Power BI
First thing first, based on my experience. We should import data to Power BI wherever possible. Importing takes advantage of the high performance query engine of Power BI, and provides a highly interactive and fully featured experience. You can connect to all sorts of different data sources when using Power BI Desktop or the Power BI service, and Read More