The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 |
---|---|
15 | |
8 | |
6 | |
6 | |
6 |
User | Count |
---|---|
24 | |
14 | |
13 | |
8 | |
8 |