Forum Discussion

powerbirino's avatar
powerbirino
Frequent Visitor
9 years ago
Solved

DAX SAMEPERIODLASTYEAR + Filter?

Currently I'm using this DAX formula on a Card and it's working:   CALCULATE( DISTINCTCOUNT(Sales[DocumentNumber]); FILTER(Sales; Sales[Field1] = "1" && Sales[Field2] = VALUE(1)) ) But, I want t...
Need Help
  • v-haibl-msft's avatar
    v-haibl-msft
    9 years ago

    powerbirino

     

    Please update the formula as below and try again.

     

    Measure =
    CALCULATE (
        DISTINCTCOUNT ( Sales[DocumentNumber] );
        FILTER ( ALL ( Sales ); Sales[Field1] = "1" && Sales[Field2] = VALUE ( 1 ) );
        SAMEPERIODLASTYEAR ( Dates[Date] )
    )

     

    Best Regards,

    Herbert

houdafrigui's avatar
houdafrigui
Regular Visitor
6 years ago

Hi, please , i was trying a formular for:  calculate , in sameperiodlastyear but with removing the day 29 of April (2019 not exsiting),

whihc one i have to use?

houdafrigui's avatar
houdafrigui
Regular Visitor
6 years ago
LastYearAmount = CALCULATE(BaseAmount,SAMEPERIODLASTYEAR('calendartable'[Date])) This is my formular that imusing for the moment