Forum Discussion
Composed_MS
Helper I
3 years agoIssue in YTD trend
Hello, I am facing issue in showing the YTD trend for the below source table.
Source table ->
YTD logic for March month = Sum of Jan users+Sum of Feb users+ Sum of March users
3
For March Amazon =(500+200+300)/3=333.33
The measure I am using is ->
Measure =
AVERAGEX(
AVERAGEX(
SUMMARIZE(
SUMMARIZE(
CALCULATETABLE(
Traffic,DATESYTD('Calendar'[Date])
)
,Traffic[Month],"Users",SUM(Traffic[User])),
[Users]),
[Users])
It is giving me correct value in card but in the trend it is giving monthly value.
It is giving me correct value in card but in the trend it is giving monthly value.
My model -> To show previous month's trend as well, I have created the Calendar2 table and my X axis is Month Year from Calendar2 table.
Measure for Trend=
Trend =
var previous_dates=DATESINPERIOD('Calendar2'[Date],MAX(Calendar[Date]),-3,MONTH)
return
CALCULATE([Measure],
REMOVEFILTERS('Calendar'),
KEEPFILTERS(previous_dates),
USERELATIONSHIP('Calendar'[Date],Calendar2[Date]))
Please help me in showing trend for YTD calculation.
Please help me in showing trend for YTD calculation.
1 Reply
- lbendlin
Super User
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216