Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Solved! Go to Solution.
@TornDigorn
Please remove the Max function that is highlighted below.
Let me know if this helps and if you have any question.
If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!
@NaveenGandhi Hello Again,
it works, but not as it should
4 (number of days) should be returned just next to the final date
Thanks for your patience 😉
@TornDigorn
Please remove the Max function that is highlighted below.
Let me know if this helps and if you have any question.
If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!
Hello @TornDigorn
Try the below DAX.
Hello NaveenGandhi
unfortunately there is a bug
@TornDigorn
Just replace the "" with BLANK(), I have made the edit to my orginal DAX as well. It should work now.
I created it as a measure, for a column you need to make this change.
Thanks,
Naveen
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
100 | |
97 | |
72 | |
71 |