Forum

What do you mean by differing layouts? Like different column headers names? A different number of columns? Different information? Could it be somethin...

There are many ways to accomplish this. I would suggest you learn pivot tables. You can see the average score for each assignment per student, see the...

How is your data set up? I'm having a hard time wrapping my mind around what you are trying to do. Can you upload an example?

Without an uploaded file, I will direct you to this article on 3 ways to transpose data. If you have any further questions please upload a sample file...

No, I used Power Query, but I did have to load the queries to the data model, but that is all I did with the data model. If you open PQ you will see t...

Maybe I overcomplicated the issue, but is this what you're looking for?

I'm having a hard time visualizing what you are asking. Can you please upload a small, anonymized sample of your workbook illustrating the issue and t...

I wonder if you could write a DAX measure that would take into account the filtering when needed and use that in a Power Pivot? I'm not sure if that i...

Can you please upload a sample of your file so we don't have to recreate it in Excel? Thank you.

Unfortunately, I don't have Power BI so I can't see the data. Hopefully, someone else can help you out that can see the data. I'm sorry.

How is the data captured? Could you use Power Query to import and filter the data? If you get stuck please upload a sample copy of your file with a mo...

Hi J C, You could use helper columns, entering what you know in those cells then in your main area you can do an if formula. IF(HelperCell<>"...

Oops sorry! I must have forgotten to attach the file, my bad. I attached it to this reply. As for your other question, is the GuestName column the ...

Hi Johan! While waiting for your example file, here is an article on how to do running totals in PQ.

Hi Justin! 1. I have attached a file where I grouped your rows by PO and product, I found the latest date by sorting by the date and adding an inde...