topic Re: Filter Date 01/01/2024 and date today in DAX Commands and Tips

Filter Date 01/01/2024 and date today

ThomazMasayuki — Wed, 15 May 2024 16:00:23 GMT

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.

Re: Filter Date 01/01/2024 and date today

bhanu_gautam — Wed, 15 May 2024 16:36:30 GMT

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

Re: Filter Date 01/01/2024 and date today

ThomazMasayuki — Wed, 15 May 2024 16:55:26 GMT

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?

Re: Filter Date 01/01/2024 and date today

Anonymous — Mon, 20 May 2024 02:57:58 GMT

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.