Forum Discussion

rodfernandez's avatar
rodfernandez
Helper I
5 years ago
Solved

Categorize data based on 3 columns

Hi, i need to create a colum that asigne a value based on other 3 columns. for example, i have this data table   ID Date Type 100 01-01-2021    1 100 02-01-2021 2 100 03-01-202...
Need Help
Show and Tell
Tips and Tricks
  • Payeras_BI's avatar
    Payeras_BI
    5 years ago

    Hi rodfernandez ,

    Find attached the pbix file with my proposal.

    EDIT: Re attached again removing some unnecessary steps and adding List.Buffer.

     

Payeras_BI's avatar
Payeras_BI
Solution Sage
5 years ago

Hi rodfernandez ,

Find attached the pbix file with my proposal.

EDIT: Re attached again removing some unnecessary steps and adding List.Buffer.

 

  • rodfernandez's avatar
    rodfernandez
    Helper I
    5 years ago

    Perfect, Thanks