Forum Discussion

ArchStanton1's avatar
ArchStanton1
New Member
2 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]),'...
Need Help
Show and Tell
  • Ritaf1983's avatar
    Ritaf1983
    2 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.

     

     

Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
2 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!

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

    Happy to help 🙂