Forum Discussion
Creating calculated rows and columns in data table
Hi, I have two basic questions about add formulas in the data table in Power BI. I would like to create new calculated columns and rows in Power Query instead of the visuals itself. Please also s...
NewbiePBI , what is the logic for these the row and the column, List operations can help
Power Query list functions : https://www.youtube.com/watch?v=oiLTUC1RCbU&list=PLPaNVDMhUXGbkShvXwEedw-cH3QBYhwvO&index=1
Hi amitchandak,
I have included the formulas for Status and Final in the snapshot. It is basically checking if all the entries for columns A to E contain "Done", if yes, display Done or Pending.
Similarly for Final Row, I am doing the same for all the column entries. Does that make the question clear?
Thanks!