Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

SUM where multiple values

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 ...
Need Help
  • selimovd's avatar
    selimovd
    4 years ago

    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
     

selimovd's avatar
selimovd
Icon for Most Valuable Professional rankMost Valuable Professional
4 years ago

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