Forum Discussion

erhan_79's avatar
erhan_79
Icon for Post Prodigy rankPost Prodigy
5 years ago
Solved

need help formula

Hi there ;   i need your small help , i have a table as below i need to calculate with a measure  only sum of the current month amount. for below sample , we are in November so current month is No...
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    Here is a measure expression that shows one way to do this.  I assume you will use this in a card visual.

     

    Sum This Month =
    VAR thismonth =
        MONTH (
            TODAY ()
        )
    RETURN
        CALCULATE (
            SUM ( TableA[Amount] ),
            FILTER (
                ALLSELECTED ( TableA[Date] ),
                MONTH ( TableA[Month] ) = thismonth
            )
        )

     

    Regards,

    Pat

     

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Here is a measure expression that shows one way to do this.  I assume you will use this in a card visual.

 

Sum This Month =
VAR thismonth =
    MONTH (
        TODAY ()
    )
RETURN
    CALCULATE (
        SUM ( TableA[Amount] ),
        FILTER (
            ALLSELECTED ( TableA[Date] ),
            MONTH ( TableA[Month] ) = thismonth
        )
    )

 

Regards,

Pat

 

erhan_79's avatar
erhan_79
Icon for Post Prodigy rankPost Prodigy
5 years ago

@mahoneypat thank you but , in my dable there is no month column, but in your formula seems "MONTH ( TableA [Month] ) " , i am working on a live connect so i can not create column about month

  • mahoneypat's avatar
    mahoneypat
    Icon for Microsoft Employee rankMicrosoft Employee
    5 years ago

    That was a typo.  It is not the Month but the Date column again.  No Month column required.

     

    Sum This Month =
    VAR thismonth =
        MONTH (
            TODAY ()
        )
    RETURN
        CALCULATE (
            SUM ( TableA[Amount] ),
            FILTER (
                ALLSELECTED ( TableA[Date] ),
                MONTH ( TableA[Date] ) = thismonth
            )
        )

     

    Regards,

    Pat