Forum Discussion
grkanth81
Helper II
2 years agoHelp 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...
- 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 - 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.
Jihwan_Kim
Super User
2 years agoHi,
Thank you for your message, and please check the below picture and the attached pbix file whether it suits your requirement.
grkanth81
Helper II
2 years agoThank you Jihwan. That worked.