Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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.
Solved! Go to Solution.
Thank you for your prompt reply! @bhanu_gautam
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.
Thank you for your prompt reply! @bhanu_gautam
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.
@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
Proud to be a Super User! |
|
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?
User | Count |
---|---|
12 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
24 | |
19 | |
14 | |
10 | |
7 |