Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi all:
I have a table a couple of columns with dates and other data. I need to calculate the average number of deployments per day, considering the complete time period between the oldest date and the newest one (that info changes when updating data on the table).
I created a couple of measures, using FIRSTDATE and LASTDATE, but the problem is that when I use a filter, those days change, based on the filter, and I need those days to be "absolute", based on the first and last date of the entire column, disregarding the filters.
I hope I'm clear enough.
Thanks in advance.
Have a great 2023!
W.
Solved! Go to Solution.
Hi walterdp,
Wrap try the following measure:
Hi,
Share some data (in a format that can be pasted in an MS Excel file), explain the question and show the expected result.
Hi walterdp,
Wrap try the following measure:
User | Count |
---|---|
85 | |
76 | |
72 | |
69 | |
56 |
User | Count |
---|---|
104 | |
99 | |
92 | |
78 | |
69 |