Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Creating Event Counts using Power Query

I am trying to convert a data cleaning process from Excel into power query in Power BI and am having trouble replicating the following Excel formula in power query: From cell D2 =IF(AND(AND(A2=A1, ...
Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    4 years ago

    NewStep=Table.Combine(Table.Group(PreviousStepName,{"ID","LACT","EVENT.O"},{"n",each Table.TransformColumns(Table.AddIndexColumn(_,"P.CNT",0),{"P.CNT",each Number.Mod(_,5)+1})},0)[n])

wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
4 years ago

NewStep=Table.Combine(Table.Group(PreviousStepName,{"ID","LACT","EVENT.O"},{"n",each Table.TransformColumns(Table.AddIndexColumn(_,"P.CNT",0),{"P.CNT",each Number.Mod(_,5)+1})},0)[n])