Measure that calculates values on current date

Hi Anonymous ,

Since I don't have your data, I have created a template based on the information you provided, which you can refer to.

If you want the month before this month with data,take below:

test = 
VAR current_date =
    MAX ( 'Table'[period] )
VAR pervious_value =
    CALCULATE (
        [number2],
        FILTER ( ALL ( 'Table' ), 'Table'[period] < current_date )
    )
VAR THISMONBLANK =
    CALCULATE (
        MAXX ( 'Table', [number2] ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[period] < MONTH ( TODAY () )
                && [number2] <> BLANK ()
        )
    )
VAR TEST1 =
    IF (
        current_date > MONTH ( TODAY () ),
        BLANK (),
        IF (
            current_date = MONTH ( TODAY () )
                && pervious_value = BLANK (),
            THISMONBLANK,
            pervious_value
        )
    )
RETURN
    TEST1

And if you want only this month with data. Use the below :

test1 = 
VAR current_date =
    MAX ( 'Table'[period] )
VAR pervious_value =
    CALCULATE (
        [number2],
        FILTER ( ALL ( 'Table' ), 'Table'[period] < current_date )
    )
VAR THISMONBLANK =
    CALCULATE (
        MAXX ( 'Table', [number2] ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[period] < MONTH ( TODAY () )
                && [number2] <> BLANK ()
        )
    )
VAR TEST1 =
    IF (
        current_date > MONTH ( TODAY () )|| current_date < MONTH ( TODAY () ),
        BLANK (),
        IF (
            current_date = MONTH ( TODAY () )
                && pervious_value = BLANK (),
            THISMONBLANK,
            pervious_value
        )
    )
RETURN
    TEST1

You could download my pbix file if you need!

Best Regards

Lucien