Forum

Hi Luciana, It's difficult to say without seeing your model. Can you please share a mock up of your file with the tables relevant to this question....

Hi Andrew, Why don't you use Slicers instead? I only recommend the VBA approach for users on Excel 2007 who don't have the luxury of Slicers. They ...

Hi Geralynn, All of the course files are available in a single zip file which can be downloaded from the top of each course's syllabus page. Myn...

Hi Mohinder, That's a great question. I'm not aware of any way to do this. Maybe there is some JavaScript you can write, but I'm not familiar with ...

Hi Maureen, The way Power Query and Power Pivot work is to store the data in the workbook that contains the connections and therefore the report. T...

Hi Scotty, Having to multiply the values by 1M is a risky solution as errors could easily creep in, but I'm not aware of any way to reverse this ot...

Hi Andrew, In session 5.08 of the Dashboard course I cover how to do this with a macro connected to a combo box. Let me know if you get stuck. M...

Hi and welcome to our forum, It appears that numbers where the 3rd value after the decimal is a 5 e.g. 207.775 have a zero appended when split by d...

Hi Tracy, Yes, 3 queries and 3 file paths in the worksheet in separate tables. Mynda

Hi LD, Welcome to our forum! You can use the 'Number Grouped Data Power Query' technique to find the first instance of each ID tagged with Prior...

Hi Tracy, There weren't any queries in the files attached. That said, if you need to get each file individually then you shouldn't be using 'From F...

Hi Mark, That is odd. Have you tested this in a new pbix file with just the example figures in question? Are you able to share the file and I ca...

Hi John, You can use Append. See attached. Note: it requires the column names to match. Mynda

Hi John, Thanks for providing the sample file. It's much clearer now. If you will always have the same number of records for each employee in th...

Hi Andrea, Welcome to our forum! It's not logical to sometimes refer to the row above and sometimes not. Rules need to be consistent. In the at...