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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
ThomazMasayuki
Regular Visitor

Filter Date 01/01/2024 and date today

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. 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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:

vjialongymsft_0-1716173654787.png

 

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

vjialongymsft_1-1716173762523.pngvjialongymsft_2-1716173785049.png

 

 

 

 

 

 

Best Regards,

Jayleny

 

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

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

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:

vjialongymsft_0-1716173654787.png

 

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

vjialongymsft_1-1716173762523.pngvjialongymsft_2-1716173785049.png

 

 

 

 

 

 

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
Super User
Super User

@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

 




Did I answer your question? Mark my post as a solution! And Kudos are appreciated

Proud to be a Super User!




LinkedIn






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? 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.