Forum Discussion
Nico_Schulze
3 years agoFrequent Visitor
Use every seventh row
Hey yall, I have an Column called "A" that has 100 Entries. In Column "B" I want to only use every seventh ROW, so ROW 7,14,21... Does someone know how I can do this? Thnak you very mu...
slorin
3 years agoSuper User
Hi
= Table.AlternateRows(Source,0,6,1)
Stéphane
Nico_Schulze
3 years agoFrequent Visitor
Hey slorin ,
your solution seems easy. But when I try to write it down in my Power BI, it doesnt work. The function Table.AlternativeRows doesnt exist. What am I doing wrong?
Thnaks for the help!
Regards
Nico