Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Dynamic filtering/column issue

**edited to clarify terminology**   Hi,   New to Power Bi and DAX and struggling with the following issue.   I have a very large dataset with properties similar to the below example data. I am ...
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Sorry, I should have been clearer. Q1 and Q3 are quartile 1 and quartile 3, not quarter 1 and quarter 3. This is an attempt to identify "outliers" in exam results data, the only time variable is year.

 

So Q3 = percentile.inc([Average Mark], 0.75) for example.

 

I will re-edit original post for clarity.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Definitely, thanks very much