Forum

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.

Did you look into the SUMIF and SUMIFS functions? IF you did and couldn't figure it out, it would be easiest for us to help if you upload your file...

Well, a pivot table needs something to summarise/aggregate. If there is noting in the Values area, every combination of FN-Year, Status and Assigned c...

Drag something in the Value area anyway, as Velouria suggested. For instance the FN-Year filed. That's a text and will automatically set it to Count. ...

See attached with some small changes in the orange shaded cells. Basically the same as Charles' solution but with a formula for the subnrs in A43 and ...