String of previous month

[Anonymous]

Hi

I need a DAX measure to return the string of the previous month. Example:

ID	Date	Level
101	10/20	Staff
101	11/20	Manager

So if the date selected in the slicer is 11/20, I need the measure to return "Staff"

[amitchandak]

@Anonymous , do you have dates or month only. can share a better sample

[amitchandak]

@Anonymous , Create a date table and try measure like

previous month value = CALCULATE(max('Table'[Level]),previousmonth('Date'[Date]))

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

[Anonymous]

@amitchandak Did not work, it gives me the current level

[AntrikshSharma]

@Anonymous  Try this:

File is attached below my signature.

Measure = 
VAR MaxDate =
    CALCULATE ( MAX ( bela[Date] ), ALLSELECTED ( bela ) )
VAR Temp =
    FILTER ( ALL ( bela ), bela[Date] < MaxDate )
VAR LastDateInTable =
    MAXX ( Temp, bela[Date] )
VAR LevelAtLastDate =
    CALCULATE (
        CONCATENATEX ( DISTINCT ( bela[Level] ), bela[Level], ", " ) ,
        bela[Date] = LastDateInTable,
        REMOVEFILTERS ( bela )
    )
RETURN
    LevelAtLastDate

[Anonymous]

@AntrikshSharma Hello

If I tell you all the columns are in different tables (that are connected), what changes in the measure?

[AntrikshSharma]

@Anonymous  If you can attach a sample file then that would help in testing the code.