Last seen: Jun 15, 2025
On the first point, I'm pretty sure that the dashboard in the video contains a formula that comes even close to the 8K character limit for formulas. S...
Without seeing the data and the desired output it's difficult to comment on alternative solutions. Though it indeed makes sense to have one entry for ...
Glad we worked that out!
Yes, let's forget about VBA for now. I believe the attached (very crude) PQ solution does what you have in mind.
You can transform the list of texts to a list of numbers by wrapping the Text.Split in a List.Transform function. Table.AddColumn(Source, "Select...
I believe you missed one short sentence in the video that isn't included in the text script. At about 3:42 into the video, Mynda says: "By the way, if...
Can you please give a clear example of how the "1 cell" may relate to "what ever tab it relates to"? Perhaps you can upload a file as well to clar...
Thanks for the file. I see a few odd things going on in the Budget sheet. You renamed the Sub-categories column to MinorCategories (cell C3) and added...
Not the most elegant solution but I believe formulae in the attached file work as intended. I've used a few helper rows (hidden with a group butto...
Perhaps you can upload the file you are working on. Otherwise we'll be guessing what exactly you have changed.
I see what you mean but can't explain it. Perhaps someone else can.
OK!
Can't really tell what the problem is. I've not come across it before. Sorry!
I don't really understand your intentions based on the example you provided and, thus, can not say what DAX measure you would need. If the formulas in...
There is no attachment. Please try again and don't forget to press "Start upload" before you submit your reply.