Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Detecting the previous row in Power Query - handling a text file

Hi, I need to import more rows from several stock info text files, treating them inside power query and then producing some KPIs. I need to manage a granularity at day and hour level. The record l...
Need Help
  • ERD's avatar
    ERD
    5 years ago

    Anonymous ,

    You can create custom columns with if/else conditions and then delete old column. Something like this:

    If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
5 years ago

Hi Anonymous 

Suggestion 1: Share your data in text-tabular format so that people trying to help can copy the table contents easily and run some tests. Just paste the table contents here, or share an excel file or a pbix with the data

 

 Please accept the solution when done and consider giving a thumbs up if posts are helpful. 

Contact me privately for support with any larger-scale BI needs, tutoring, etc.