Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have the below code in M that gives the number of days between the start date and end date (it works fine):
[EndDate]-[StartDate]
But if I try to subtract "1" then I get an error:
[EndDate]-[StartDate]-1
I assume it's because [EndDate] and [StartDate] are stored as dates but "1" is an integar? Please do you know how to fix?
Thanks,
CM
Solved! Go to Solution.
Replace 1 by: #duration(1,0,0,0)
Replace 1 by: #duration(1,0,0,0)
User | Count |
---|---|
100 | |
89 | |
82 | |
76 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |