Ficial-DateNo

SSAS, SSIS, and SSRS

What are SSAS, SSIS, and SSRS? Microsoft SQL Server provides many tools to manage and utilize your data. SSAS is Microsoft SQL Server’s Analysis Services which is an online analytical processing (OLAP), data mining and reporting tool used in Business Intelligence to make your data work for you. SSIS stands for Sql Server Integration Services. The key […]

Ficial-DateNo

How to Create a Calculate Column for The Same Day of Last Year

You can create a calculated column in Calendar Dimension: SameDayLY= var TodayDate = TODAY() var LastYear = YEAR(TodayDate)-1 var LastMonth = MONTH(TodayDate) var LastDay = DAY(TodayDate) return ‘Calendar'[Date]= DATE(LastYear,LastMonth,LastDay) This solution shoule be good for most of the situation. However, your way returned a true value for “2019-03-01” if Today date was a Leap day […]

Ficial-DateNo

How to Build a Power BI Dashboard for Mobile Correctly

4 steps to build Power BI dashboard for Mobile correctly In this article, we will learn how to Optimize a Power BI dashboard for mobile phones.  What is a Power BI dashboard?  How to create a power bi dashboard for mobile phones? What is a Power BI dashboard? A Power BI dashboard is a feature of the […]

Ficial-DateNo

How to Sort a Chart by Different Axis in a Power BI reports

 Important This article is intended for Power BI users who do not have edit permissions to the report or dataset and who only work in the online version of Power BI (the Power BI service). If you are a report designer or administrator or owner, this article may not have all the information you need. Instead, please read Sort by column […]

Ficial-DateNo

How to Combine Data From Multiple Files in a Folder

We have two options to combine the files. Combine and Transform Combine and Load In this article, we will see how to use ‘Combine and Transform’. Have a look at the files.  See below the structure of each file, Employee1    Employee2   Employee3   Follow the below steps to combine and transform the data. Step 1 To import data, go […]