Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Statement based on monthslicer

Hi all,    I'm new with Power BI and queries. The situation is as folllowed:   I'm using the following measurement to calculate the cost per hire over a year. CPH = SUM(Recruitmentchannel[cost])...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    CPH = IF(HASONEVALUE('Table'[Month]),SUM(Recruitmentchannel[cost])/12/Countrows(NewEmployees),SUM(Recruitmentchannel[cost])/Countrows(NewEmployees))

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

CPH = IF(HASONEVALUE('Table'[Month]),SUM(Recruitmentchannel[cost])/12/Countrows(NewEmployees),SUM(Recruitmentchannel[cost])/Countrows(NewEmployees))