Forum Discussion

Tarun0055's avatar
Tarun0055
Regular Visitor
4 years ago
Solved

Previous month calculated column for Text fields

Hi , I have headcount table where I need to create a calculated column for employee team of previous month. Please find sample data and the expected  result. Emp no job effective date team  p...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi, 

    Please check the below picture and the attached pbix file.

    It is for creating a new column.

     

     

    Previous Team CC =
VAR _currentdate = Data[job effective date]
VAR _currentemp = Data[Emp no]
RETURN
    SUMMARIZE (
        FILTER (
            Data,
            Data[Emp no] = _currentemp
                && EOMONTH ( Data[job effective date], 0 ) = EOMONTH ( _currentdate, -1 )
        ),
        Data[team]
    )
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
4 years ago

Hi, 

Please check the below picture and the attached pbix file.

It is for creating a new column.

 

 

Previous Team CC =
VAR _currentdate = Data[job effective date]
VAR _currentemp = Data[Emp no]
RETURN
    SUMMARIZE (
        FILTER (
            Data,
            Data[Emp no] = _currentemp
                && EOMONTH ( Data[job effective date], 0 ) = EOMONTH ( _currentdate, -1 )
        ),
        Data[team]
    )