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.
Hi All,
I have a column called entry date in Table A and created a date table called DateDim having column Date.
When I'm creating the below measure I'm getting error.
Solved! Go to Solution.
Hi, @Anonymous
According to your description, you want to get the date diff between the max date of your selected date and the 'Process Detail'[entry_date], you can try my method:
Datediff =
var _selecteddate=MAXX(ALLSELECTED('DateDim'),'DateDim'[Date])
return
DATEDIFF(MAX('Process Detail'[entry_date]),_selecteddate,DAY)
And You can download my test pbix file here
If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.
How to Get Your Question Answered Quickly
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Anonymous
According to your description, you want to get the date diff between the max date of your selected date and the 'Process Detail'[entry_date], you can try my method:
Datediff =
var _selecteddate=MAXX(ALLSELECTED('DateDim'),'DateDim'[Date])
return
DATEDIFF(MAX('Process Detail'[entry_date]),_selecteddate,DAY)
And You can download my test pbix file here
If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.
How to Get Your Question Answered Quickly
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , you need to use aggregation and row context
refer my blog : https://community.powerbi.com/t5/Community-Blog/Decoding-Direct-Query-in-Power-BI-Part-2-Date-Difference-Across/ba-p/934397#M451
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 | |
94 | |
83 | |
67 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |