Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Solved! Go to Solution.
Hello @Anonymous
Give this a try, you will just need to change the table and column names to match your data.
Filtered Sales = CALCULATETABLE( Sales, DATESBETWEEN ( Sales[Sales Date], DATE(2019,1,15), DATE(2019,2,5) ) )
This creates a new table called 'Filtered Sales' that is the Sales table filtered to 1/15/2019 - 2/5/2019
How can I create a measure to get the values for one specific date,
I created a variable for the date, but the calculate(measure, filter(date=variable date)) returns a blank result
Hi @Anonymous ,
You can set date range directly.
Table = VAR DateStart = DATE ( "2018", "1", "5" ) VAR DateEnd = DATE ( "2018", "1", "15" ) RETURN CALCULATETABLE ( TEST, FILTER ( TEST, TEST[Date] <= DateEnd && TEST[Date] >= DateStart ) )
Or you can set a start time and time interval to define your date range.
Table 2 = VAR DateStart = DATE ( "2018", "1", "1" ) RETURN CALCULATETABLE ( TEST, DATESINPERIOD ( TEST[Date], DateStart, 15, DAY ) )
You can define the time interval by day, month, season, year. Here is the documentation for DATESINPERIOD() function.
https://docs.microsoft.com/en-us/dax/datesinperiod-function-dax
These two DAX queries return a same table. You can choose one of them.
Here is my test file, you can click the following link and download it.
Best Regards,
Eads
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello @Anonymous
Give this a try, you will just need to change the table and column names to match your data.
Filtered Sales = CALCULATETABLE( Sales, DATESBETWEEN ( Sales[Sales Date], DATE(2019,1,15), DATE(2019,2,5) ) )
This creates a new table called 'Filtered Sales' that is the Sales table filtered to 1/15/2019 - 2/5/2019
Hello, is there any option using the filter parameter used in the report? Because i'm trying but the selected date not filter
Thank you so much! Your method worked for me
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |