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.
Hello,
New to this, still muddling my way through learning. I have an issue i'm trying to solve.
I have been asked to retrieve some data:
Days to Hire (For those with a date in the Hire (GO) column, what is the average days between the Date Column and the Hire (GO) column?)
Table with two date columns Hire (Go) and Hire.
What would be the best approch to this in a measure.
Thanks,
- Dane
Solved! Go to Solution.
@SoundCheese You can start by having a calculated column that gives you difference in days between two dates and then take the average out of that column. To get average number of days that took for hire you don't have to write any calculations you can just use visuals and Quick Calc feature to get average of the total of difference in days coumn. Check out this page and scroll down to Quick Calc explanation.
@SoundCheese You can start by having a calculated column that gives you difference in days between two dates and then take the average out of that column. To get average number of days that took for hire you don't have to write any calculations you can just use visuals and Quick Calc feature to get average of the total of difference in days coumn. Check out this page and scroll down to Quick Calc explanation.
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 |
---|---|
114 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |