Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

0

Data Value

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")

Min.png

 

Status: Delivered

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

Comments
v-xiaoyan-msft
Community Support
Status changed to: Investigating

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
Advocate II

Vielen Dank für Ihre Antwort

v-xiaoyan-msft
Community Support
Status changed to: Delivered

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