Forum Discussion

wnicholl's avatar
wnicholl
Icon for Resolver II rankResolver II
3 years ago

Need help with moving months

Hello,
 
I need a dax formula that will automatically update the next month i.e.: From (2023,05,31) To (2023,06,30) at the end of the month.  Below if my current formuala that needs to be manully updated at the end of the month.  Any help will be greatly appriciated!  Thanks in advance.    
 
2023 NB =
CALCULATE(
COUNTA('AISCVGP'[ACCUS#]), FILTER('AISCVGP', AISCVGP[ACSTA] = "ACT"),
FILTER('AISCVGP', AISCVGP[ACNOR] = "N"),
DATESBETWEEN('Calendar'[Date], DATE(2023,1,1), DATE(2023,05,31)))
Need Help

2 Replies

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

    Only from syntax perspective, you can use

     

    =
CALCULATE(
    COUNTA( 'AISCVGP'[ACCUS#] ),
    AISCVGP[ACSTA] = "ACT",
    AISCVGP[ACNOR] = "N",
    CALCULATETABLE(
        DATESBETWEEN(
            'Calendar'[Date],
            STARTOFMONTH( 'Calendar'[Date] ),
            ENDOFMONTH( 'Calendar'[Date] )
        ),
        'Calendar'[Date] = TODAY()
    )
)

     

    • wnicholl's avatar
      wnicholl
      Icon for Resolver II rankResolver II
      3 years ago

      Thanks for reaching out. That formaula works except I'm not getting the result I need. Thank you!