Forum Discussion

ArchStanton1's avatar
ArchStanton1
New Member
3 years ago
Solved

Blank out Future Values in Chart

Hi,

 

Is there a way I can stop the black line at September so it only populates months that are current or in the past?

 

DD YTD Cases = CALCULATE(
    			TOTALYTD(COUNT('Cases'[Case Number]),'Date2'[Date],"31/3"))

 

Thanks,

Need Help
Show and Tell
  • Ritaf1983's avatar
    Ritaf1983
    3 years ago

    Hi  ArchStanton1 , there are several ways to filter out months without data for example :
    Submitted_cases = calculate([DD YTD Cases], FILTER(ALL(Date),Date[Date]<=max(Date[Date])))

    For a more detailed solution please share a dummy file to work with.

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

     

     

3 Replies

  • Ritaf1983's avatar
    Ritaf1983
    Icon for Super User rankSuper User
    3 years ago

    Hi  ArchStanton1 , there are several ways to filter out months without data for example :
    Submitted_cases = calculate([DD YTD Cases], FILTER(ALL(Date),Date[Date]<=max(Date[Date])))

    For a more detailed solution please share a dummy file to work with.

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

     

     

    • ArchStanton's avatar
      ArchStanton
      Icon for Power Participant rankPower Participant
      2 years ago

      Hi Rita, Apologies for the delayed acknowledgment, i thought I had already responded & approved this.
      Your solution works perfectly!