Forum

Hi Theo, Please see post no 5 above, the code is already posted there.

You're wellcome 🙂 Keep in mind that the solution is based on the StartDate and EndDate, it ignores the Hours column, the new rows will always have...

Hi Chris, You can use this query, that will expand the rows where there are more than 8 hours: let Source = Csv.Document(File.Contents("...

Hi Darshan, You will have to provide more details, screenshots there is no clue about what you are doing and what does not work. Thank you for u...

Hi Matthias, You can try this code: Note that the icons on the desktop of that user may be messed up when you change the resolution.

Hi Matthias, Does that other computer have a different display resolution? Try recording the same macro on his computer, you will see the differ...

Hi Rosemary, What do yo mean by "excel table not linked when added to data model"? After adding a table to Power Pivot, you should create the relation...

Great, glad to hear you managed to make it work Catalin

Hi Maurizio, I can help you with the download image part: Option Explicit Private Declare Function URLDownloadToFile Lib "urlmon" _ Alias "...

Hi Benedikte, Indeed, long numbers are not properly handled in Power Query, I had the same problem with UPC codes, which are basically a 12 digit n...

Hi Pablo, Indeed, the DateTime.AddZone is missing from october 16 specs, but you can find it online: In october 16 specs, you can find something ...

Hi Daniel, Assuming that the data table is sorted by date, smallest to largest, you can use these 2 formulas to get the first and last matches: ...

Hi Theo, A simple index-match combination should work: =D6*(1+INDEX({0.1,0.15,0.2,0.25,0.3,0.35,0.4},MATCH(D6,{0,15000,20000,25000,30000,50000,6...

Hi Rita, A simple excel formula will do the trick: =B2&COUNTIFS($A$2:A2,A2,$B$2:B2,B2) (assuming that data starts from row 2 and in colum...

Hi, You can try this function: = IF ( ISBLANK ( Table1[discount] ), CALCULATE ( MAX ( table1[discount] ), FILTER ( A...