Forum

Try this: = Table.AddColumn(#"Removed Other Columns", "Custom", each Text.Combine(List.RemoveMatchingItems(Text.Split([Sought from]," "),Text.Split...

Hi Carolyn, Without seeing the file in context, can't help you. Can you please open a ticket here:we should setup a desktop sharing session so I c...

Try "Ignore privacy levels"

Hi Vivian, From power query editor window, go to File-Options and settings-Query Options. You will find there the privacy settings for the query, a...

You keep changing the pivot context, you had before shop ID, now you have month. Many times, if you change the pivot context, there is a good chance f...

If you have those 3 measures, all you have to do is to use them: DistinctON:=CALCULATE(DISTINCTCOUNT(tbtesting[Shop ID]),tbtesting[Status]="On") ...

Hi Carolyn, No screenshot attached. Hard to say why there is no connection, usually they do not disappear. But you do have better options to ...

Hi, You cannot use that column in PQ, add Ticker symbol as a new column from that stock data, use this for grouping.

Hi Michael, Start with this example then upload your test file here to see what can be done. You should be able to add another formatting rule with...

Hi Sonia, Take a look at the code in Advanced Editor. Wherever you have to expand a table, column names are hard typed when you do this operatio...

Maybe it's best to edit the picture to mark the lines you mentioned with an arrow, might help us understand what you need.

Hi Nicolas, What lines are you trying to get rid of? Gridlines? If yes, just click on a line and press the delete key.

Try: =COUNTIFS(DIS!B:B,"Taimani",DIS!B:B,"chaman",DIS!B:B,"Khushalkhan",DIS!E:E,"Group Loan",DIS!E:E,"GMRB")

Hi Dalasamoud, Try: Total Shop:=CALCULATE(DISTINCTCOUNT(tbtesting[Shop ID]),tbtesting[Status]="On") For SUM, use a similar measure (you alrea...

Hi Srinivasa, Not sure why you had that error, I just right clicked your table and Refresh, the data was fully displayed. Make sure you have the...