Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

TOTALYTD until a specific date

Hi everyone,

 

Maybe the TotalYTD is not the good function for my purpose but I don't find my answer :-(.

 

Can someone could help me please? 

 

3 tables: RevenueLines (G_L) ; Calendar and Closing and the link between them in color.

 

3 measures : the first-two are OK but not the third.

 

Thanks for your help

 

Need Help

6 Replies

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

    Anonymous , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

     

    If you need YTD based on today, not based on selection, you can try a measure like

     

    YTD=
    var _min = date(year(today()),1,1)
    var _day = today()
    return
    CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Date] >=_min && 'Date'[Date] <= _day) )

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi,

       

      No. My problem is about summing all the amount of account "70" from the first day of the year until the closing date which came from an other table. 

       

      This is the yellow part of my screen capture.

       

      Thanks

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        amitchandak I need to replace the "today var" by the closing date coming from the table "closing". But I can't manage it

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

       

      The very last part doesn't work 😞 amitchandak 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

     

    What the [70] is in the measure2?

     

    Best Regards,

    Jay