Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Update on formula - Year

Hello Team,   I usually show sales of the previous month with the below expression:   Sales-1 = Calculate(     Sum(Sales_Main[Price_Excl_VAT]),     Month(Sales_Main[Date_Vente])=Month(Today())...
Need Help
Show and Tell
Tips and Tricks
  • Samarth_18's avatar
    Samarth_18
    3 years ago

    Hi Anonymous ,

    Please try below code:-

    Sales-1 =
VAR _prev_month =
    MONTH ( EOMONTH ( TODAY (), -1 ) )
VAR _prev_year =
    YEAR ( EOMONTH ( TODAY (), -1 ) )
RETURN
    CALCULATE (
        SUM ( Sales_Main[Price_Excl_VAT] ),
        FILTER (
            Sales_Main,
            INT ( MONTH ( Sales_Main[Date_Vente] ) ) = INT ( _prev_month )
                && INT ( YEAR ( Sales_Main[Date_Vente] ) ) = INT ( _prev_year )
        )
    )
Samarth_18's avatar
Samarth_18
Community Champion
3 years ago

Hi Anonymous ,

Please try below code:-

Sales-1 =
VAR _prev_month =
    MONTH ( EOMONTH ( TODAY (), -1 ) )
VAR _prev_year =
    YEAR ( EOMONTH ( TODAY (), -1 ) )
RETURN
    CALCULATE (
        SUM ( Sales_Main[Price_Excl_VAT] ),
        FILTER (
            Sales_Main,
            INT ( MONTH ( Sales_Main[Date_Vente] ) ) = INT ( _prev_month )
                && INT ( YEAR ( Sales_Main[Date_Vente] ) ) = INT ( _prev_year )
        )
    )