Forum Discussion

JoeAPH's avatar
JoeAPH
Regular Visitor
7 years ago
Solved

Introducing Month field from Calendar changes YTD calculation

I have a measure     Sales YTD = CALCULATE([Ttl Sales], FILTER(trans,year(trans[DATE])=MAX(Calendar2[Year])), FILTER(trans,trans[Hold?]="n"))   Note: Ttl Sales = Sum(trans[NetSales])   I...
Need Help
  • JoeAPH's avatar
    JoeAPH
    7 years ago

    Hi

     

    I added the RETURN command, and it is working perfectly!

     

    Many thanks

     

    Joe

JoeAPH's avatar
JoeAPH
Regular Visitor
7 years ago

 Hi

 

Thank you for your time!

 

No. Calendar cust off at current day.

 

Joe

JoeAPH's avatar
JoeAPH
Regular Visitor
7 years ago

cuts*