Filter Date 01/01/2024 and date today

[ThomazMasayuki]

Hi guys! 

I need make DAX using period 01/01/2024 and today about all informations and users can filters between 01/01/2024 and today update every day. 

Any people can for me? Tank you support. 

[Anonymous · Accepted solution]

Thank you for your prompt reply! @bhanu_gautam 

Hi @ThomazMasayuki 

You can use the following DAX to create a filtered table:

Table 2 = FILTER('Table','Table'[Date]>=DATE(2024,1,1) && 'Table'[Date]<=TODAY())

Then you can then put the filtered date column into the slicer to filter the date segment you want:

Or you can create a separate date table and then relate the date columns to the date columns of the original table

Table 3 = CALENDAR(DATE(2024,1,1),TODAY())

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[bhanu_gautam]

@ThomazMasayuki , You can create a dax measure for this using filter function

TotalSales =
CALCULATE(
SUM('Sales'[Amount]),
FILTER(
'Sales',
'Sales'[Date] >= DATE(2024, 1, 1) && 'Sales'[Date] <= TODAY()
)
)

Suppose if you are looking for sum of sale amount you can use given formula

[ThomazMasayuki]

Nice man. Tank you support. 

Now, how I use this DAX for Filter for users. For example, I publish my dash everyday and, others users view informations. In this case, I need show dates for filters and visualize. 

In this case, why visual I create?