Forum Discussion

mrslyfox's avatar
mrslyfox
Helper II
8 years ago
Solved

division into even and odd

Dear Colleagues,   Looking for ideas how to create calculated columns which can represent results in the folowing way Date Customer Product Product ID Customer Order Nr Number of Carriers ...
  • Lind25's avatar
    8 years ago
    You can do this using Power Query Editor.
    Add an index column starting at 1. Then transform this using standard > modulo with a divisor of 2.