Thursday, May 12, 2022

How to calculate and create a YTD Sales Trend or Growth Chart in Power BI

Calculate YTD Sales and create a Line Chart to show Sales Trend using Power BI
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
--------------------------------------------------------------------------------------------------------
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.

Featured Post from this Blog

How to compare Current Snapshot Data with Previous Snapshot in Power BI

How to Dynamically compare two Snapshots Data in Power BI Scenario: Suppose, we have a sample Sales data, which is stored with Monthly Snaps...

Popular Posts from this Blog