Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Help with YTD Line Chart - Display Different Months by Scenario Dimension

I'd like to present YTD values for Budget and Forecast, but stop Actual at current month. Actuals flat line past August is killing me!

 

zAllOytd = 
 TOTALYTD([ORDER_£M],
    tblDate[Date])
    //tblDate[Date],tblDate[YTD]="X") this has the filter I'd like to use for Actuals...i think?

 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Anonymous , Always use date table, try like

     

    zAllOytd =
    calculate([ORDER_£M],
    datesytd(Date[Date]) , Date[Date] <=today())

     

    or

     

    YTD =
    var _max = min(MAX( 'Date'[Date]) , today())
    var _min = eomonth(_max,-1*MONTH(_max))+1
    return
    CALCULATE([net] ,DATESBETWEEN('Date'[Date],_min,_max))

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      The issue is that I want all 12 months to display for budget & forecast, but only through month X to dispaly for actual.