Sales for particular year_DAX query help

[Reddyp]

1. I want help in writing DAX for calculating "sales" for particular year (example:sum of sales where year  = ‘1900-01-01 00:00:00')

2. for the above DAX formula I need to add "location" of store, ("sales" for particular year where location is "Auckland")

[Samarth_18 · Accepted solution]

Hi @Reddyp ,

You could try below code:-

CALCULATE (
    SUM ( Table1[Amount] ),
    FILTER ( Table1, Table1[Date] = DATE ( 1900, 01, 01 ) ),
    FILTER ( Table2, Table2[Location] = "Auckland" )
)

BR,

Samarth

[amitchandak]

@Reddyp ,

calculate( sum(Table[Amount]), filter(Table, Table[Date] = date(1900,01,01)  && Table[Location] = "Auckland") )

[Reddyp]

@amitchandak this can't be worked when "Location" details are on different table (Table 2) right ?

calculate( sum(Table1[Amount]), filter(Table1, Table[Date] = date(1900,01,01)  && Table1[Location] = "Auckland") )

help me out in applying filter on columns from different tables