Forum

Hi Marianne, yes, this may be another way to solve it. What Mynda says, is that you should add a new column in Power Pivot Invoice Line table, with...

Can you attach the file you mentioned?

Choose connection as you need, choose comments, or Feed, and expand all the tables, to see what they contain. You can group and count friends by gende...

Hi Troy, If you can upload a sample file with data, I will show you how you can do what you want. The view you are describing is in fact a filte...

Hi Marianne, JSON strings can be anywhere from simple to very complex, on multiple levels, some fields can hold simple values, other fields can hav...

Hi Troy, From Power Pivot window, you can create a Pivot Table report (this will be a power pivot table, not a regular excel pivot table). In th...

Of course it's possible. The JSON string must probably is saved in a text file, with .txt extension. You can use the option From File-From Text,...

Hi Emma, Have you tried the ABS function? It will always return a positive value, no matter if the difference is positive or negative: =ABS(A2-A1) ...

Hi Julie, Can you upload a sample file with your query? I have to see it to understand what is happening there. Cheers, Catalin

Hi Kevin, As I already said, the code is based on the Worksheet_Change event. See this tutorial for workbook-worksheet-events-excel-vba The code is...

Hi Deepak, Check your data, there should not be other data types than dates in that column. If your column contains mixed data types (text, numbers...

You're wellcome Anne 🙂 No idea why the replacement does not work, as you can see in the query I did the replacement and it works (replacing a spac...

Hi Anne, The Replacement will work in power query too, not only in the source data, you can do it as a step in your query. You need to transform...

You're wellcome 🙂

looks like the cell is not blank, you have a space there. Try to type a space in Value to Find field, and "null" in the Replace wiith field. Expand th...