Forum Discussion

grkanth81's avatar
grkanth81
Icon for Helper II rankHelper II
2 years ago
Solved

Help with creating a new measure or column

Hi, Can you please provide your suggestions to create a new measure or column  in the below scenario ? I have created a dummy data set which has some columns and values. I would like to create a ne...
  • Jihwan_Kim's avatar
    2 years ago

    Hi,

    I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.

    Please check the below picture and the attached pbix file whether it suits your requirement.

     

     

     

     

     

    Expected result measure: =
    VAR _workhours =
        SUM ( Data[HoursWorked] )
    VAR _fte =
        SUM ( Data[FTE] )
    VAR _noofmonth =
        SELECTEDVALUE ( Period[No of Months] )
    VAR _result =
        DIVIDE ( DIVIDE ( _workhours, _fte ), _noofmonth ) * 12
    RETURN
        _result
    

     

  • Jihwan_Kim's avatar
    Jihwan_Kim
    2 years ago

    Hi, 

    Thank you for your message, and please check the below picture and the attached pbix file whether it suits your requirement.