Forum Discussion

AnaAlbano's avatar
AnaAlbano
Helper I
5 years ago

Monthly Average Headcount

Hello Community!    I´m starting my DAX journey and I wonder if you could help with this question: I´m trying to calculate the average headcount considering the beginning of the month and end of th...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

AnaAlbano , for end of the month you can use closingbalancemonth with help from date table 

or try lastnonblankvalue and  firstnonblankvalue

 

example

calculate( lastnonblankvalue('Date'[Date], Sum(Table[Headcount])) + firstnonblankvalue('Date'[Date], Sum(Table[Headcount])) , allexpect(Table, Table[Month Year]))/2