Forum

Would be helpful if you could also include the expected results in your file. Calculated manually, that is. I find it hard to 'translate' the rules in...

Just drag any column into the Value field and make sure it's being counted and not summed. I took Years as it was the first column in the table.

I also downloaded the file and created the pivot table as Mynda suggested. Rather then using COUNTIF on 810K rows, I used a VLOOKUP to pickup the coun...

Make sure that you have a Calendar table, linking the date field in dt_StudentResults to the date field in the Calendar. then, build your visual based...

When you copy and paste form one column to another, structured table references do not behave like their direct cell reference counter parts. You woul...

I had to Google a bit and learned something of it myself and came across the following post: Solved: Re: DAX equivalent of =sumifs, based on row co...

Okay, the attached file contains a slightly different solution, but I believe it is what you asked for. The idea is that you connect PQ to the blue ta...

MY gut feeling says that if you can use pivot tables, go for it. I would not put any effort into creating complicated formulas. Mynda has a blog po...

I'll get back to you tomorrow (my time). At CET 9PM now.

Could get into the CSV only by right-clicking on it and then save as a file file. The system suggested it was an html file. I changed the extension t...

Please try uploading the file again. This time, press 'Start Upload' and wait until it's done before you submit your reply.

I find it difficult to relate your (perhaps overly simplified) example file to your questions/remarks. It seems you have all data (PQ cleaned) in seve...

This would work: #,##0.00" Est"

Okay! Let's give it another try and let's combine the first part of your query with the last part of mine. As you can see, English PQ calls the functi...

When you create a structured table, Excel put the filter buttons in the header rows. You can use these to filter but also to sort columns.