Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Calculate value with multiple months

Hello all,   I am very new to power BI and stuck on this. Seems very simple but can't figure it out.    When i select multiple months, I would like the Rev targets value to add together.   ...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    Hi Anonymous 
    This is how it works as a default if the Rev target  data type is a number

    If the data type is correct and it is still isn't working, please attach a link to your pbix .

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

Hi,

Ensure that you create a Calendar Table with calculated column formulas for Year, Month name and Month number.  Sort the Month name column by the Month number column.  Create a relationship (Many to One and Single) from the Date column in your Fact table to the Date column in the Calendar Table.  To your slicer, drag Year and Month name from the Calendar Table.  Write this measure

Total = sum(Data[Amount])

Hope this helps.