Forum Discussion
Solved
Need help with DAX (Month)
Hey! everyone I would like to show 2 month which composed of current month and next month but i have begining Value only current month so I would like to cal ending inventory of current month ...
Hi Amp_ ,
At first, you need to create a new column.
Rank = RANKX ( 'Table', 'Table'[Date],, ASC, DENSE )
Then create your “Ending Inventory” column based on it.
End = CALCULATE ( MIN ( 'Table'[Begin] ), FILTER ( 'Table', 'Table'[Rank] = EARLIER ( 'Table'[Rank] ) + 1 && 'Table'[Name] = EARLIER ( 'Table'[Name] ) ) )Here is the result.
Best Regards,
Eads
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
