Forum

Trond Liavik said Running totals AMOUNT: There should be no flat graph from 201906-12, running totals is just repeating itself then. Here period amou...

Hi Trond, I doubt that MDX is easier than DAX. I think they are equal in complexity, it simply depends on user specific training and abilities. An ...

Hi Lannie, In Power Query Editor, what settings you have for Data Source Settings? (go to Home Tab>Data Source Settings) There should be 2 ob...

Try this : let Source = Folder.Files("C:Usersc3hamDocumentsCount data"), #"Filtered Rows" = Table.SelectRows(Source, each Text.EndsWith([Extensio...

Hi Carl, Without a sample file with data, there are small changes to receive an answer, nobody can test a solution with unknown data structure. ...

Hi James, It is possible, but there are some inconsistencies in your data. If product name is null, then qty and price should be null in all sectio...

Hi Craig, you should apply a filter to your query, to load only the last 12 hours data. First, add a parameter to detect the highest date in you...

Hi Denise, Using the automatic "Combine Data" button provided by power query is not very flexible, you should avoid that if there may be changes in...

Hi Dinah, Please continue this topic, do not create new topics with replies to the same problem.

Hi Chandra, Number.Round has multiple rounding modes, have you tried them all? Here is a link to the resource, you have multiple examples on that p...

Hi Gayatri, The worksheet_Change event provides an argument named Target: Private Sub Worksheet_Change(ByVal Target As Range) The calculate e...

Hi Gayatri, In this case, instead of monitoring K4 and L4, put in code the ranges that you are actually editing manually that can cause changes in ...

Hi Stefano, After you paste the link and choose next, a new dialog should show up: Access Web Content, on the left side you should have 5 authentic...

Hi Roxana, Go to Data tab, Connections section, and click on Connections button. Select WorkbookConnectionTable1 and choose Remove, this is the one...

Hi Melanie, I see you have a code for setting the next number, you just need to call the NewInvoice code after you save as pdf: Sub CommandB...