SUM where multiple values

[Anonymous]

Hi, 

I need to create a calculation whereby I need to sum a value (fact_comp.value) where date.currmonth_offset is in (0, -1, -1, -3, -4, -5, -6, -7, -8, -9, -10, -11, -12, -13)

Any idea how I would write out the Dax for this, please?

[selimovd · Accepted solution]

Hey @Anonymous ,

sure, you can use that as filter arguments in CALCULATE:

Sum of Value =
CALCULATE (
    SUM ( fact_comp[value] ),
    date[currmonth_offset] IN { 0, -1, -1, -3, -4, -5, -6, -7, -8, -9, -10, -11, -12, -13 }
)

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic