Видео

The simplest solution with basic end user function, merge the two table twice. First merge is with the first column, and then the second column. Other method may be handling the transfomation using either List or Record.

You will need to use List.Accumulate if the input is from previous step.

@jeromeastier462 What did you get when you use the auto detect data type from the UI? I'm trying to determine whether you need a clean-up step before data type.

The “detect data type” UI does return the column with a decimal number as a text. I tried with a sample csv file with 2 one record and three columns, and it still does not recognize the number a a number. When I force it by clicking on the left hand ABC column header then “1.2 decimal Number”, then it does transform it as a decimal. Could the problem be that at the source, all columns are labeled “text” - not undetermined as when it comes from an xlsx file?

@jeromeastoer462 there are few things that can potentially cause this issue. Happy for you to email me the sample CSV and I'll have a look at it instead of back and forth. Reach me out through LinkedIn.

@@bsmart2gether408 thank you very much KT, much appreciated. Just want to add that your videos are stellar!

Thank you for such a big compliment.

Hi Anil, I had to pause it for a while due to family commitments. I'll post it once my personal situation changed. Thank you for your support and understanding.

Were you referring to the example in the video?

Yes!

X is the seed, which is the starting point. ruclips.net/video/CBlqD1vR2bc/видео.htmlsi=sP9fdz1DzxgoBsUq explained more about the List.Accumulate function.

​@@bsmart2gether408obrigado!

Thank you for your compliment. You can handle it as part of your input or change the calculation.

I'm glad you find it helpful.

You need to convert the number to text with the List.Transform function if you were attempting to combine the value. Is there any particular errors you get?

Expression.Error: We cannot apply operator & to types Text and List. Details: Operator=& Left=1 Right=[List]

It saying you tried to combine text with list, which is not possible. You must have a nested list when you are trying to perform the combine. If you are trying to append lists, you will need to convert the text into a list quoting { text }. I hope it helps.

I appreciate your responses. I'll tinker with the code. I used the code on your video at 6:28. Keep pushing your content, very effective!

I'll need to look at your code to be able to determine the problem. From face value, its likely the problem is nested list with transformation to join text. 6:28 is the code constructed by Jo for a challenge. Are you doing the same challenge?

I'm glad you find it useful. ☺️

I'm glad you found something that help you. SUM is very useful. It depends on the v situation to decide which function suit your situation. If we use SUMX for most cases and it is unnecessary, you will get slow performance as SUMX calculate each row. When you need aggregate level, or sum of a column, you use SUM instead of SUMX (i.e., you don't need to go throught each row). Also, when you use pivot table, the default is SUM. I hope it make senses. I'm more than happy to answer 😊

Thank you so much for such a big compliment 😊

Are you referring to two tables and find differences?

I'm happy to assist. Reach me out through LinkedIn or PBI community

U didn't mention your LinkedIn or email in your about section 😢

Google Bsmart2gether and you should be able to see it

I'll provide it through LinkedIn. Ping me through LinkedIn.

Thank you, @rrrrassscccc80 for your kind compliment 😊

Thank you, @vacilando86. Glad you think so!

Hi @jeromeastier462, Thank you for your compliments ☺️

Thank you, @isabellachen5704 for your kind feedback. It is only a demonstration rather than tutorial. I am more than happy to do tutorial video to create chart (one at a time).

@@bsmart2gether408 👍👍👍looking forward to them!

Hi @zbatevp-vlogs610, Thank you so much your support. The key to the dynamic expanding columns is to be able to refer to a dynamic list. There are multiple way to achieve it. If you want to exact match " List.Select(List, each _ <> "Suburbs") " or you can change '<>' to '=' KT

@@bsmart2gether408thank you for the response I will try to apply this. Kindly keep on sharing your skill... you have amazing stuff here.

Hi, Table.Join is a good option for filtering. One tips - add a step to only capture the criteria column(s) to prevent users accidentally add new column, which may cause errors as Table.Join spill all columns from the join table. KT

Thank you for your feedback. Greatly appreciated 🙏

Definitely will 😊

Thank you, I'll add it to my list

Thank you, Anil

Thank you, Sumanth. I don't transform in a same way as I always change and try to find better way.

Hi Daniel, it is depends. The general use cases are when you have aome that ypu reference to it numerous time, then it is ideal to apply the buffer function as it stores in the memory rather that evaluate it every time.

​@@bsmart2gether408obrigado!

My pleasure @roywilson9580. 😊

Hi, I will watch the video tomorrow and get back to you. The video posted ages ago, and I don't remember the content. KT

Hi Joshi, You can make the second and third arguments in conditional statement at the same time. For example, second argument [Column] = something returns boolean (i.e., either TRUE or FALSE), and third argument also performing a conditional then it means you try to find true or false, which value is not exist. You can write conditional statement in the second argument this way: if [Column] = something then A else B, and the outcome will return either A or B and as long as it returns value for searching. I hope I clear the confusion. Regards KT

@@bsmart2gether408 Thank you very much for the guidance. I am trying to understand.... However, since I am quite new, I cannot fully grasp. I will get back to you if I need further guidance. Thanks a lot....

Let me simply the explainaation a bit. The requirement for the second argument is value and it search for the value in the column you specified in the fourth argument. This is driven by the function you set in the third argument, the replacer function. Replace the function to a conditional function is literally change the logic. I hope it make sense. The best way to understand it is to try the code in various way. I hope it helps. KT

@@bsmart2gether408 It does help for sure. Again I am thankful for your guidance and keen interest taken in my query. I have started regularly watching your videos. Pl keep on sharing. Regards

Thank you. I replied through your second comment.

Thank you for your compliments. Would you mind explaining a bit more what you mean by reverse with a simple example?

I'm glad you like it.

I'm glad you find it useful.

Thank you, @Sumanth1601. The second example was requested by @mirrrvelll5164. It is very practical. 🙂

Hi Stefano, Thank you so much for your compliment.

Hi Alex, I am glad you find it useful 😊

That's so true 😁

Hi @anuurag6011, It is not easy to explain it here as it could caused by various factor. Click on the link will take you the microsoft document about how to import csv/text. I hope it resolves your problem. Otherwise, please raise your problem in power bi community and I'll address it from there. learn.microsoft.com/en-us/power-query/connectors/text-csv

@@bsmart2gether408 Thanks, I think it's power query version difference, because the dataset completely delimited in Office 2021, but in 2016 it's not.

@@anuurag6011 How is handle through various Excel can be slightly different as it improve overtime. However, some basic challenge like import csv/text can still be resolve through modifying the M code. If you have some sample data that you have challenge with. I am happy to look at it.

Okay, how to share

The best is through Power Platform Community and tag Bsmart2gether. That'll would benefit the broader community.

Mirrrvelll, zip file can be tricky. Custom connector required to decompress the file using the binary function. I attempted once in the past but beyond my know back then. I know it is possible, might attempt it again sometime in future.

Thank you, Jerome