Forum Discussion
Select the last day value dynamically
Hi guys i am new to power bi i need to calculate the stock of the last day dynamically. For example i having stocks from january 2018 to November 2019. I want to calculate the last day stock value s...
Try
Last Day of month Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(sales,Sales[Sales Date]=ENDOFMONTH('Date'[date])))
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601