PBI-DataVizzle/DAX_LatestMTD.md

Created April 26, 2022 13:20

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/PBI-DataVizzle/2267a917ac9038d5965e2ed9eb46ea9c.js"></script>
Save PBI-DataVizzle/2267a917ac9038d5965e2ed9eb46ea9c to your computer and use it in GitHub Desktop.

Download ZIP

Latest MTD calculation

Raw

DAX_LatestMTD.md

Measure | CFYTD =
// current fiscal year to date of [BaseMeasure]
VAR _ytd =
    CALCULATE ( MAX ( _Dates[LatestMTD] ), REMOVEFILTERS () )
VAR _result =
    CALCULATE (
        [BaseMeasure],
        KEEPFILTERS ( _Dates[Date] <= _ytd ) 
        // , Dates[IsCFY] = TRUE
    )
RETURN
    _result
// IF(  NOT ISBLANK( [BaseMeasure] ) ,  _result  )

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment