Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

previous Year Last day value

Hi All, I got requirement to calculate latest inventory below condition . My matrix report structure below : Year 2018 2019 2020 Inventory 50. 60. 70 Above actually dril...

DAX Calculation

Power BI Desktop

stevedep
6 years ago
Last day inventory is the latest stock part, dateadd minus 1 year to see the value of the year before?

Icon for Memorable Member rank

Memorable Member

6 years ago

For the latest stock you can look at:
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Stuck-in-DAX-Create-calculated-table-from-date-based-last-values/m-p/1132982/highlight/true#M16845

Anonymous
Not applicable
6 years ago
Hi stevedep ,

I am looking for to find out the year last day inventory available value .
Ex, 2020 should show the value captured on 31 may 2020 only , not the cumlative jan 1 2020 to may 31 2020 .
- stevedep
  Memorable Member
  6 years ago
  Last day inventory is the latest stock part, dateadd minus 1 year to see the value of the year before?