No worries. By the way, I'd just like to compliment you on your content and all the work you do, it is simply awesome.
Yep, I know. What I meant to say previously is I think the reason I couldn't tell that you filtered the column using the drop down button is because ...
No worries, I think I know what it is: when I opened the query I got a compatibility warning; it seems I might be using an older version of Excel or P...
Mynda Treacy said Hi Tykru, Please see Excel file attached. You can do this with Power Query by extracting the various pieces of data and then mergi...
I've tried both Catalin's and your suggestion and they work great. However, when I round both 1 decimal place, the DAX version will round way up (i.e....
Awesome, I will take a look at both and see what works for me. I considered using DAX in Power Pivot but am only working from one table so I didn't ad...
Sorry I thought I already replied. This is perfect. Thanks Mynda!
Thanks Mynda. I think this is a bit more complicated than I initially thought because I'd like to see what the increase since last invoice is but not ...
I tried rearranging the pivot but I don't want the invoice date and # in the table, just PO# and the sum of total hours by PO#, and then the increase ...
Each PO (purchase order) is tied to only one project, and the total hours represent how many hours the engineer billed for technical review work relat...
Thank you so much for the quick reply, Mynda. I hadn't known about this handy feature, however, is there a way to do it without the date field? I'd li...
Sorry for not including sample data. I'm trying to add 2 columns to the query. I would to create 2 new columns (Previous Hours & Increase Since La...