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.
Hi,
I have data like this:
date[datetime], count of days[int], ticket ref[int]
I want to put a flag on each row where it is an increment of 5, e.g. 5, 10,15,20,25 and so on. This can go into the hundreds so I wanted to make it dynamic.
Tried this:
if List.Contains({List.Numbers(5,500000,5)},[Days Idle]) then "true"
else "false"
That didn't work I am assuming because list.numbers won't work with list.contains as that requires the numbers to be split out.
Could someone please steer me in the right direction?
Many Thanks
POC
Solved! Go to Solution.
I think you can use
Number.Mod(theColumn, 5)
just test the result against 0. If it's 0, then it's divisible by 5
I think you can use
Number.Mod(theColumn, 5)
just test the result against 0. If it's 0, then it's divisible by 5
Perfect thank you, it did indeed work. now I just target 0 as the filter 🙂
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 |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |