Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |