Forum Discussion
How to get value based date filter
i have data table values and date column
Table 1
sales period flag
450 01-03-2021 1
234 01-04-2021 2
450 01-05-2021 3
234 01-06-2021 4
450 01-07-2021 5
234 01-08-2021 6
i am trying to get value june month value on using dax filter
junval=calculate(sum(sales),filter(table1,table1[period]='01-06-2021'))
but this measure not working . any idea how to get values based on the date column
If your period is stored as a text data type, then I'd expect this to work:
junval = CALCULATE ( SUM ( table1[sales] ), FILTER ( table1, table1[period] = "01-06-2021" ) )Note that sales needs to table1[sales] and I used " instead of '.
4 Replies
- AlexisOlson
Super User
If your period is stored as a text data type, then I'd expect this to work:
junval = CALCULATE ( SUM ( table1[sales] ), FILTER ( table1, table1[period] = "01-06-2021" ) )Note that sales needs to table1[sales] and I used " instead of '.
AlexisOlson period stored as a date format
- AlexisOlson
Then you can use DATE ( 2021, 6, 1 ) instead of "01-06-2021" or else the month = 6 approach Jihwan_Kim suggests.
- Jihwan_Kimjunval =CALCULATE (SUM ( Table1[sales] ),FILTER ( table1, MONTH ( Table1[period] ) = 6 ))
