Forum

Thanks for the file. When you speak of machines you actually refer to product lines. Correct? My first thought was that you can't combine two bars ...

Hi Mike, Could you please upload the file from which you took the screenshots? That would make it much easier to answer your question. Riny

Hi Chuck, The attached file contains an example with two conditional formatting rules to mark numbers greater (green) or less (red) than the one in...

Glad I could help! Ciao

Hi Ricardo, That's because you incorrectly constructed the pivot table. The Activities, hours and Percentages need to go to the value area of the p...

Crossposted and answered here:

Glad I could help!

Hi Patrick, Have a look at the attached file and see if you can follow. Duplicated your query and created my own with some extra clean-up steps, re...

That generic form would look like this: = Table.AddColumn( Source, "Custom", each Number.Sqrt ( Number.Power([A],2) + Number.Power(,2) ) ) I tru...

First save the file with the existing query with another name and then change the Source step. Just point it to the new file.

I suppose you know how to create a Pivot Table. Put the PR field in the Row area and also in the Value area. Then, change the Field setting for the la...

Hi Paul, VLOOKUP returns a value for the first match it finds. Your formula look only for the name "Claudiu Negru" and the first hit happens to be ...

Hi Pieter, In case you are interested in an all-in-one version that doesn't require a function, try this script: let Source = Excel.CurrentW...

Thanks! I can now link the pbix file to its xlsx source. but there's not much going on in the pbix file. It contains a report with three visuals. Is s...

When I open your pbix file and look at the "anncillary_expenses" table, I note that the last column is full of "NaN" (not a number). The visual itself...