cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MrMarshall Regular Visitor
Regular Visitor

Dax - FY Cumulative total on Average budget for a smooth graph

Main problem, I am trying to make my budget line go a little bit smoother in my FY-graph. It only got rows in the first day in each month and looks like a staircase...

 

 I am calculating the FY cumulative budget and sales with the same formula:

Sales FYTD = CALCULATE(SUM(Sheet3[Sales]), DATESYTD('Calendar'[Date], "30/9"))
Budget FYTD = CALCULATE(SUM(Sheet1[Budget]), DATESYTD('Calendar'[Date], "30/9"))

I also made a formula for the Average budget and it's working, but I can't figure out how to make it cumulative...

Budget Average Per Day = 
CALCULATE (
    AVERAGEX ( Sheet1 , Sheet1[Budget] ),
    DATESINPERIOD (
        'Calendar'[Date],
        LASTDATE ( 'Calendar'[Date] ),
        -1 ,
        MONTH
    )
)

Anyone got an idea of how to make the average budget added upp on FY total?

Problem:

Screenshot_180.png

 

 

I made an example for you to try on! Smiley Happy 

 

 

2 REPLIES 2
Community Support Team
Community Support Team

Re: Dax - FY Cumulative total on Average budget for a smooth graph

Hi @MrMarshall,

 

I'm afraid there isn't a good way to do that. Because the budget table only has values for the first day of the month. That means the other days of the month will be empty or the same with the first day if we accumulate the values. So there could be always an angle.

How about removing the Day level? 

Dax-FY-Cumulative-total-on-Average-budget-for-a-smooth-graph

 

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support Team
Community Support Team

Re: Dax - FY Cumulative total on Average budget for a smooth graph

Hi @MrMarshall,

 

Could you please mark the proper answers as solutions?

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.