Forum Discussion

pfarahani's avatar
pfarahani
Icon for Helper II rankHelper II
5 years ago
Solved

calculation using current month

Hi All,   Is there a way to calculate a simple measure like, total count of something (filings) but in a way that it dynamically updates with the current month of the data. For example, I have this...
Need Help
  • pfarahani's avatar
    pfarahani
    5 years ago

    Hi Greg, Greg_Deckler I am having success with this:

     

    Value on Last Year/Month =
    CALCULATE(
    COUNT( 'JBSIS Probate Filings'[Case Number] ),
    FILTER( 'JBSIS Probate Filings', 'JBSIS Probate Filings'[Report Year Month] = MAX( 'JBSIS Probate Filings'[Report Year Month] ) )
    )
pfarahani's avatar
pfarahani
Icon for Helper II rankHelper II
5 years ago

Hi Greg, Greg_Deckler I am having success with this:

 

Value on Last Year/Month =
CALCULATE(
COUNT( 'JBSIS Probate Filings'[Case Number] ),
FILTER( 'JBSIS Probate Filings', 'JBSIS Probate Filings'[Report Year Month] = MAX( 'JBSIS Probate Filings'[Report Year Month] ) )
)
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
5 years ago

pfarahani Yep, I can see how that would work too!