Forum Discussion

anelliaf's avatar
anelliaf
Icon for Helper II rankHelper II
6 years ago
Solved

Current YTD Costs Displayed as a Static Card

Hello,   I'm trying to calculate the current YTD costs.  The current formula I have is:   PY - Sales = CALCULATE([SumOfCosts], 'Usage Details - 2'[Year])   The problem is it's displaying past ...
Tips and Tricks
  • anelliaf's avatar
    anelliaf
    6 years ago

    I think I got it.  I chose the card and the year filter on the page, and then selected 'None' for interactions.  It looks like it is holding up.  I have a few more filters to test to see if that's the case.  Thanks for everyone's help so far.

bfernandez's avatar
bfernandez
Icon for Resolver II rankResolver II
6 years ago

This can be accomplished using the Visual Level filter.

 

You can use the date correlated to the [Usage Details - 2] column.

 

Select the card you would like to be filtered and do the following in the Filters pane:

 

  • anelliaf's avatar
    anelliaf
    Icon for Helper II rankHelper II
    6 years ago

    I tried this approach before, but when I select a previous year, i.e. 2019, it changes the card value to 'Blank'?