Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a date column, in that, I want to add a certain days value in order to get future 5 days by adding the day's column value as a loop.
In the example provided below, I have added "86.83" days from the MTBF - Days column to the Last Failure Date column"6/28/2018 12:42". And got the first Future Failure 1 value of "9/23/2018 8:37", then created a loop to create the next 4 future failure dates.
If anyone can help me with the problem it will be of great help. Thanks in advance.
Solved! Go to Solution.
@Anonymous ,
You may add a custom column in Query Editor first.
List.Generate(()=>1, each _ <= 5, each _ + 1)
@Anonymous ,
You may add a custom column in Query Editor first.
List.Generate(()=>1, each _ <= 5, each _ + 1)
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |