Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Calculate volume next month

Hi guys,   I've the following table columns: VOLUME, PEOPLE and EOMONTH. I need to calculate the volume of the next month like the example bellow:   VOLUME PEOPLE EOMONTH Calc_Column 43 ...
Show and Tell
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    Here is a column expression with one way to do it.  Replace Volume with your actual table name.

     

    NextMonth =
    VAR vNextDate =
        EOMONTH (
            Volume[EOMONTH],
            1
        )
    RETURN
        CALCULATE (
            SUM ( Volume[VOLUME] ),
            ALLEXCEPT (
                Volume,
                Volume[PEOPLE]
            ),
            Volume[EOMONTH] = vNextDate
        )

     

    Pat

parry2k's avatar
parry2k
Icon for Super User rankSuper User
5 years ago

Anonymous you can easily achieve this using the DAX time intelligence function called NEXTMONTH, You need a date table in your model to make it work, and that you can easily add it by looking at my blog post here.

 

Check my latest blog post Improve UX: Show Year in Legend When Using Time Intelligence Measures | PeryTUS IT Solutions  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to 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.⚡

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi parry2k, I know how to create a new date table to do this, but my ask was about to do this in the same table. Ty