Previousmonth Dax

[Venussuda]

Hi , 

I must have done something wrong. date filter may be 
I would like to compare overtime outstanding openingbalance , endofbalance every month

My DAX is below : 

EndofPrevmonth =

CALCULATE(SUMX('Tíarkontur 24 01 2021','Tíarkontur 24 01 2021'[Total Balance]),FILTER(ALL('Tíarkontur 24 01 2021'),SUMX(FILTER('Tíarkontur 24 01 2021',EARLIER('Tíarkontur 24 01 2021'[Date]) = LASTDATE(PREVIOUSMONTH('Tíarkontur 24 01 2021'[Date]))),[Total Balance])))

Total Balance = [Normal Time]+[Overtime 50 %]+[Overtime 100 %]+[Unnormal Hour]

Netchange = [Total Balance]-[EndofPrevmonth]

The total pr month pr department is correct,  but pr. person is incorrect, It´s showing the same no. which is a total pr. month actually.... why is that? what have I done wrong? how to fix it

Thanks in advance.

[v-henryk-mstf]

Hi @Venussuda ,

Maybe the reason for this error is the incorrect use of the FILTER function in the created EndofPrevmonth measure. You may wish to change the judgment condition after the filter function, and then see if the result has changed.

If the problem is still not resolved, you need to provide specific data model or test data, otherwise I may not be able to help you do further testing. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Venussuda , There are functions for opening balance and closing balance.

Can you check if those can help - Refer my videos

https://www.youtube.com/watch?v=yPQ9UV37LOU

https://www.youtube.com/watch?v=6lzYOXI5wfo