To show YTD Sales growth Momentum, first we need to Calculate the YTD Cumulative sales.
We can calculate the new YTD_Sales measure based on the existing Gross_Sales measure , using below DAX Expression or Forumula.
YTD_Sales = TOTALYTD(SUM(FactSales[Gross_Sales]),Tbl_Calendar[Date_Id])
Here, Tbl_Calendar is a related Table whose [Date_Id] has a relation with [Order_Date] of the the [FactSales] Table.
Now we can see the YTD_Sales calculated in below Cross Tab ( Matrix ) Report.
Based on this data we can build a Line Chart Dashboard, which shows the Gross_Sales by Month, and a Trend Line showing the YTD_Sales growth. Also, I have added a Slicer here for Region_Name
YTD_Sales = TOTALYTD(SUM(FactSales[Gross_Sales]),Tbl_Calendar[Date_Id])
Here, Tbl_Calendar is a related Table whose [Date_Id] has a relation with [Order_Date] of the the [FactSales] Table.
Now we can see the YTD_Sales calculated in below Cross Tab ( Matrix ) Report.
Based on this data we can build a Line Chart Dashboard, which shows the Gross_Sales by Month, and a Trend Line showing the YTD_Sales growth. Also, I have added a Slicer here for Region_Name
--------------------------------------------------------------------------------------------------------
Thanks, TAMATAM ; Business Intelligence & Analytics Professional
--------------------------------------------------------------------------------------------------------
No comments:
Post a Comment
Hi User, Thank You for visiting My Blog. Please post your genuine Feedback or comments only related to this Blog Posts. Please do not post any Spam comments or Advertising kind of comments which will be Ignored.