Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now

0
Tito

Data Value

Submitted by Helper IV on ‎03-21-2023 06:20 AM

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
See more ideas labeled with:
3 Comments (3 New)
Comments
Anonymous
Not applicable
‎03-21-2023 11:55 PM

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
Helper IV
Helper IV
‎03-27-2023 02:21 AM

Vielen Dank für Ihre Antwort

Anonymous
Not applicable
‎03-29-2023 06:49 PM

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

Idea Statuses