Data Value

[Tito]

Hello everyone,
how can I use a DAX function to determine the value Sales on 02/15/2020, for example.

I use the following DAX formula but it doesn't work:

Sales 15.02.2020 = CALCULATE(SUM(Tabelle1[Sales]), Tabelle1[Date] = "15.02.2020")

[v-xiaoyan-msft]

Hi @Tito ,

First make sure your date is not in text format, if it is, we suggest you change it to Date format.

Please try :

Measure = CALCULATE(SUM('Table'[summe von sales]),FILTER(ALL('Table'),'Table'[date]=DATE(2020,2,15)))

Best regards.
Community Support Team_ Caitlyn

[Tito]

Vielen Dank für Ihre Antwort

[v-xiaoyan-msft]

Vielen Dank für Ihr Feedback. Dieser Thread wird geschlossen.