Last seen: Apr 30, 2025
You seem to be quite advanced in DAX and it's difficult for me to add anything without seeing your file/model. However, you may want to look into the ...
Great! Perhaps one of the other frequent contributors here can help with a more solid (DAX) solution for you.
I see what you mean but can't really get my head around how to do this with DAX measures in PP. Most likely I would do the ground work in Excel before...
Perhaps you can upload a file with all of this. Quite a bit of text and formulas to read through and difficult to follow if one doesn't see it in cont...
Please clarify which averages you expect to see if you were to calculate them manually.
I assume that whenever you enter a number in T, it's always the same as the total in S. Otherwise you can never count he pairs issues by size. In t...
Unfortunately, the screenshot didn't load. Please try again. This time, press the 'Start upload' button, wait until it's finished before pressing Subm...
Don't think that's possible with regular Pivot Table. Have even looked at Power Pivot with a DAX measure. you can suppress the yearly percentages but ...
According to the MS support pages, the new "in-cell" checkboxes are E365 (PC, Mac and Web) only.
Glad I could help. Keep learning!!
Well, if you don't want VBA but do have Excel for MS365 (as Hans suggested) you could create separate tables for each Site where you do all the change...
I was actually going on auto-pilot here, doing what I always do without much further thought about alternative solutions. The attached file now inc...
Wanting the Master to update the site data and vice versa would require VBA, I believe. And that's something I stay away from. Why not create a sep...
Not sure I got it right, but looking at the Expense Data, the attached file contains a query that I would want to create before analysing the data. If...
You were almost there. Although, I would have done it only a little bit different when it comes to splitting the date and time as demonstrated in the ...