Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi to everyone,
i have this list, numbers from 1 to 12 {1..12},
for extracting 1,4,7,10 i use = List.Alternate(Source,2,1,1)
for extracting 3,6,9,12 i use = List.Alternate(Source,2,1,0)
How can i extract 2,5,8,11?
Thank you!
Solved! Go to Solution.
ts correct i was searching a way for using onlyList.Alternate, but its not possible
= pls try this code
= List.Alternate(List.Range({1..12},1),2,1,1)
thank you!
hi @dufoq3 thank you for your answer, i tried it but i got 1,2,5,8,11
Have i to add a step that exclude the first number? I need only 2,5,8,11
User | Count |
---|---|
8 | |
7 | |
5 | |
5 | |
4 |
User | Count |
---|---|
14 | |
13 | |
8 | |
6 | |
6 |