I still haven't come across a problem that you didn't already make a video about! Thank you once again! Power BI is starting to get popular within the staff at the company I work for and I make sure to direct all of them to your channel before anyone else's!
@CurbalEN
2 жыл бұрын
Thank you!!! 😊😊
@larsbengtsson3216
2 ай бұрын
Thank You! Saved me hours of work!🙂
@jamiushobajo6824
Жыл бұрын
Hi Ruth, thank you. This was clear and helpful, 3 years later. 😊
@davidcadman3562
3 жыл бұрын
Hi Ruth, fyi this tip really helped me after Black Friday to quickly deduct the value of a single sale (that we incorrectly tracked with Order Value 1 million EUR!) Just one thing I had to figure out myself was the format of the Date as #date( 2020, 11, 27 ) within Table.InsertRows(). Thanks.
@RESUMAOAUDIOBOOKS
5 жыл бұрын
Obrigado Ruth. Muito bom! Estou aprendendo muito com suas aulas.
@CurbalEN
5 жыл бұрын
Muchas gracias ! Todo un placer ayudar :) /Ruth
@cg24356
2 жыл бұрын
I needed this today and will apply it tomorrow. You are awesome! That is so great. Thank you very much for all of your videos
@CurbalEN
2 жыл бұрын
My pleasure and thanks for the feedback!
@taivos
3 жыл бұрын
Just wanted to stop by and say thanks. MS documentation didn't do me much good as I needed to add a few hardcoded lines, though the tutorial here is excellent. Keep up the good work, grattis!
@CurbalEN
3 жыл бұрын
Thanks, really appreciate you took the time to give me feedback :) Enjoy your Saturday!
@yemisiadeoluwa5810
3 жыл бұрын
Thank you so much this is super useful. I was thinking about this just this week then I saw your video. More help please keep on with the good work
@dapperlink
3 жыл бұрын
Curbal, you can read my mind! However, it's time to expand on this subject. If you're taking ideas, here's one. I have a row of let's say 2 columns. I need to conditionally search for a row based column content, copy the row's content and insert/paste it below that row (or above). That more mimics something we do all the time in Excel that would be wonderful to do in Power Query. Thank you for what you do!!
@MisterMoT
2 жыл бұрын
This was very handy code for me today to add 7 rows to my table. Thanks!
@poojamathapati7673
3 жыл бұрын
Thank you so much. Exactly what I was looking for!
@kebincui
Жыл бұрын
Awesome video. Thanks Ruth.
@ClaudiaGarcia-qn4ly
2 жыл бұрын
Hi Ruth. Thank you for posting these amazing and useful videos. You have helped me a lot. You are Great! :)
@CurbalEN
2 жыл бұрын
😊
@fredericpinchon504
2 жыл бұрын
Merci pour votre vidéo.
@CurbalEN
2 жыл бұрын
vous êtes le bienvenu
@akrimnialhabil4541
Жыл бұрын
Again, awesome video, thanks for your video 👍
@celinexu6598
4 жыл бұрын
Hi Ruth, do you have any suggestions, adding measure as row directly in table visualization? I have a financial statement table and having 4 account names in the record. however, in the reporting table, I need to show all 5 accounts with value (the 5th account which is the account 2 minus account 4) I am using 'table' or 'matrix' any suggestion? Thank you so much!
@bongi_nkuna
2 жыл бұрын
Hi there, did you ever find a solution to this problem, I have a similar problem
@Faridahjames
4 жыл бұрын
Thank you, This was Super useful!
@borecz161
5 жыл бұрын
Bravo!. While DAX is easy for me, M is soo hard so this helped me a big time.
@CurbalEN
5 жыл бұрын
You are probably one of the few in the world that can say that!! Congrats :) /Ruth
@HarshNathani
4 жыл бұрын
Thanks for the video Ruth. How can we do this insertion of rows at the end of the table. For E.g i always want a blank row with index value at the end of the table to support my other calculations.
@jeffbrady100
4 жыл бұрын
Hi Ruth! I really appreciate your series this is so selfless of you. I am attempting to use this and add many rows to another table instead of using append, I believe that I need to use EACH in the power query statement and I am struggling with the syntax for that. Can you help me?
@CurbalEN
4 жыл бұрын
Hi Jeffrey, don’t I show in the video how to add multiple rows? Thought I did? /Ruth
@ilovenatureiloveculture5776
3 жыл бұрын
Thank you for this great video! What is the right format to input a date?
@CurbalEN
3 жыл бұрын
It will depend on your regional settings
@kennethstephani692
2 жыл бұрын
Great video!
@paulosouza4565
4 жыл бұрын
Congratulations on the class! #Brasil
@mauriciopriego1700
3 жыл бұрын
Thank you, Ruth.
@pedrovitor8909
4 жыл бұрын
Dear Ruth You are awesome Thanks a lot, I'm learning a lot with you Hugs from Brazil
@CurbalEN
4 жыл бұрын
Obrigada! /Ruth
@claraptj
4 жыл бұрын
This saved me so much time!! Thank you so much
@fabsrox1837
Жыл бұрын
THANK YOU SO MUCH!!
@josepromero1452
5 жыл бұрын
My mouth is still open!! Really cool!!! Thanks Ruth!
@CurbalEN
5 жыл бұрын
Agree, it is a cool trick! /Ruth
@abdelalisdoud2626
4 жыл бұрын
Thank you for this great video. Can you please tell me what you use as software so you can display your video above the background page (here Power BI Desktop) ?
@CurbalEN
4 жыл бұрын
I use camtasia :) /Ruth
@dbszepesi
4 жыл бұрын
My Hero, as usual!! Thanks!
@CurbalEN
4 жыл бұрын
Thanks! 😊 /Ruth
@reng7777
4 жыл бұрын
Nice and wonderful tip!!!!
@masoomali14
4 жыл бұрын
Hi Thanks for your great video ,I have two tables one is history other one is live refresh. I want to insert rows in to history from live refresh on weekly basis. Can we use other table's rows as values instead of hard coded value?
@CurbalEN
4 жыл бұрын
Interesting question and I havent done it myself and from the top of my mind I am not sure how it could be done. Check in the power bi community to see if someone has any ideas! /Ruth
@madiakns
4 жыл бұрын
Hi Ruth, I have a question.... I have Monthly sales data (Actual and Plan). I need to create a bar graph in a way that every end of the quarter shows after the months of the quarter. Exp: Jan Feb Mar Q1 Apr May Jun Q2 Jul Aug Sep Q3 Oct Nov Dec Q4 Is it possible to add Quarter data with in the table/graph?
@MarkCBB86
5 жыл бұрын
Very helpful, thank you Ruth
@CurbalEN
5 жыл бұрын
Thanks Mark! /Ruth
@robsonnascimento5935
3 жыл бұрын
Many thanks for this video, helped in an Job :)
@CurbalEN
3 жыл бұрын
Wonderful to hear :)
@kapilsharma1704
5 жыл бұрын
you are doing good !
@CurbalEN
5 жыл бұрын
:) /Ruth
@Sal_A
5 жыл бұрын
Hi Ruth - Your original table had other columns but you manipulated and inserted a row called "Other" for the ProductName2 column. How do you show the other columns of the original table after you made the change?
@vfontanav
2 жыл бұрын
You are awesome!
@CurbalEN
2 жыл бұрын
Thanks!
@123jamalq
5 жыл бұрын
Excellent Ruth.
@CurbalEN
5 жыл бұрын
Thanks Jamal! /Ruth
@Геннадій-ц8э
4 жыл бұрын
That is great functionality! Thanks for sharing that. Can we add rows from another table instead of writing new rows manually?
@CurbalEN
4 жыл бұрын
Yes, you append tables :) /Ruth
@sidharathsarvesh6904
4 жыл бұрын
Hi Ruth - Thanks for the amazing videos you make! I'm stuck with a problem, and it is like: I'm preparing a Power BI dashboard that displays category wise data for a month. I've another input sheet that has the information on category wise trend over last few years. Now, I want to combine the latest data from the dashboard with the historical trend data and displays that in a chart/graph. Also, the trend have to be UNPIVOTED before creating a chart. I've been banging my head against the wall for quite a while to no solution. PLEASE HELP!
@FareyFraction
5 жыл бұрын
Thanks for sharing this useful tip!
@CurbalEN
5 жыл бұрын
My pleasure! /Ruth
@mohtasimbillah3068
4 жыл бұрын
can we add rows in data based on some conditions?? lets say if i have values 1 and 5 in two columns of same row and i want to add more rows having missng values between 1 and 5.. so output having all rows 1,2,3,4,5
@MartynHale
5 жыл бұрын
Hi Ruth, Will the new rows remain after a full refresh - I ask this because my understanding is that data in the model gets completed replaced during refreshed?
@CurbalEN
5 жыл бұрын
Hi Martin, it will. Power Bi will go through all the steps specified in power query and will add the rows when it gets to that step during the refresh. Try it and you will see :) /Ruth
@FredericLEGUEN-Excel
3 жыл бұрын
Hmmm, interesting but dangerous. I didn't know this M Code but it could be dangerous to add rows directly in the code. Usually, all the data should be in your source (file or database). If something is missing, that means your data source are not correct and you must correct them (not adding rows in M). Well that's my opinion. But great explanation as usual 😉
@duyoan3042
3 жыл бұрын
This is helpful a lot!!!! thank you very very so so much x3.14
@pratikfutane8131
5 жыл бұрын
Great addition ⚡
@CurbalEN
5 жыл бұрын
Awesome! /Ruth
@akshaykatkam8703
3 жыл бұрын
Hello, here is what I am trying to do: I have a table, say, "Test 1" that has data from January till May (pulled in from an excel workbook). Now, I have data for the month of June in an Excel workbook (say "Test 2".xls"), which I want to append to the existing data. Using the Append query function helps me do this, but only once. I need to be able to do this every month, by hitting refresh. (The new data will be saved in the same path). Is there a way to do this?
@ChetanAdivinnavar
8 ай бұрын
I have 3 calculated tables which are derived from the main table. How can I append them in single table. Thank you
@pedrovitor8909
4 жыл бұрын
Ruth How would you describe the uses of [ ] on m functions? I can't detect a pattern!!!! Thank you!
@CurbalEN
4 жыл бұрын
Check this video: m.kzitem.info/news/bejne/z3ua3p6CmJqGmG0 :) /Ruth
@pmsocho
5 жыл бұрын
Cool!
@CurbalEN
5 жыл бұрын
:) /Ruth
@davidfamilydoctor9430
4 ай бұрын
Thanks. Now if my table has 25 fields/columns, seems like appending a table with the extra row or rows would be easier.
@AlphaRhoDelta
Жыл бұрын
How do you add values in the rows you just created?
@kudosnitin976
3 жыл бұрын
how to add N times multiple rows with column values based upon the previous column values?
@Sal_A
3 жыл бұрын
How do you dynamically add a new row to the last record of a table?
@NirRobinson
5 жыл бұрын
🔥🔥🔥🔥
@CurbalEN
5 жыл бұрын
I’ve little trick right ? ;) /Ruth
@venkateshbabu9750
3 жыл бұрын
How to add column 2 columns from one table to another table but stuchers data will be different
@wayneseymour1
4 жыл бұрын
Why is excel power query adding a unwanted column to the appended table when I refresh the data ?
@siddeshmundhe6536
5 жыл бұрын
Hi Ruth I am from India . Can you please Add subtitles on your videos.
@CurbalEN
5 жыл бұрын
Hi Siddesh , check this video to see if it helps you : m.kzitem.info/news/bejne/xK5r1IlromWXdY4 /Ruth
@saialekhyachitturi6035
4 жыл бұрын
HOW TO ADD NEW COLUMNS
@alenaulasenka2917
8 ай бұрын
It doesn´t work well for table with more than 1 column
@9zQx86LT
2 жыл бұрын
you said.. "convert it to a list" .. but converted it to a table? did I miss something?
@CurbalEN
2 жыл бұрын
I did most likely 😂
@dhanunjaiahd2359
2 жыл бұрын
In Excel Simply one click to add rows, but in power query writing so much of drama bullshit........
@CurbalEN
2 жыл бұрын
The same is true for most of the data cleaning you would do in excel. It is always a trade off
@computek9141
2 жыл бұрын
Wow, estas bien bonita en ese video.
@pawewrona9749
2 жыл бұрын
Hello, here is the piece of code to add a new row for all the columns in the table, hope it's useful :) TableColumnNames = Table.ColumnNames(#"Changed Type"), #"Converted to Table" = Table.FromList(TableColumnNames, Splitter.SplitByNothing(), null, null, ExtraValues.Error), AddOthersColumn = Table.AddColumn(#"Converted to Table", "Column2", each "Others", type text), TableToRecords = Record.FromList(AddOthersColumn[Column2], AddOthersColumn[Column1]), InsertNewRow = Table.InsertRows(#"Changed Type",0,{TableToRecords}) in InsertNewRow
@cvbusagmailcom
5 жыл бұрын
Congrats on another year as MVP. What software and hardware do you use for your very nice green screen effects -- you live video in front of an active computer screen. Thanks. Charles.
@CurbalEN
5 жыл бұрын
I use elgato green screen and camtasia :) I have a link of my gear in the description box. /Ruth
Пікірлер: 97