Forum Discussion
DAX/Formula HELP!
Sorry for the vague subject - I am unsure how to categorize this. I am attempting to predict the inventory for the rest of the year. I currently have ending inventory data for months 1 through 5. To ...
Anonymous try this measure
Measure 3 = SUMX ( FILTER ( ALL ( Bal[MONTH] ), Bal[MONTH] <= MAX ( Bal[MONTH] ) ), CALCULATE ( SUM ( Bal[ADDITIONAL] ) ) ) + CALCULATE ( SUM ( Bal[BEG INV] ), Bal[MONTH] = 1 )I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
parry2k
Super User
Super UserAnonymous try this measure
Measure 3 =
SUMX (
FILTER ( ALL ( Bal[MONTH] ), Bal[MONTH] <= MAX ( Bal[MONTH] ) ),
CALCULATE ( SUM ( Bal[ADDITIONAL] ) )
)
+ CALCULATE ( SUM ( Bal[BEG INV] ), Bal[MONTH] = 1 )
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
Awesome - thank you so much!