PS - Two weeks in self-quarantine finally gave me time to work on this five year old goal. In your ~/.bashrc place the following: lll () )\33[m\n"Īs always don't forget to re-source with. I played with du and tree but could not get the totals I needed. It is just missing a file count and size of files at the bottom.
This can be done in the Add Column ribbon.I'm conditioned to the ll command which is aliased to ls -alF. Since there is no standard transformation available in the Power Query interface to remove the last character, we need to resort to a little bit of M programming (also called the Power Query formula language).įirst we need to add a new calculated column. To solve this issue, we need to remove that final backslash. This would result in an unnecessary empty column at the end, but also empty strings (instead of NULLs) in intermediate levels. However, when you take a look at the folder path in the example, you can see that each path ends with a backslash. The folder path can easily be split by the Power Query user interface by using the backslash as a delimiter.
This will make it easier to aggregate to a specific level. However, if we want to do a bit of analysis on the file sizes per folder, it might be useful to split up the folder path into different columns, where each column represents a specific level of subfolder. In the Power Query ribbon, go to the section Get External Data, click on From File and then navigate to From Folder. To print only the file name and size we can run the below command from a batch file. The above command prints file modified time also. For example, to get file size for mp3 files, we can run the command ‘dir. Power Query is also part of the Power BI ecosystem and is integrated in Power BI Desktop. We can also get size for files of certain type.
0 kommentar(er)
