Forum Discussion
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 ...
Hi Anonymous ,
See if these help
https://community.powerbi.com/t5/Desktop/Dynamic-Quartiles/m-p/814004
https://sqldusty.com/2018/08/31/calculating-quartiles-with-dax-and-power-bi/
https://community.powerbi.com/t5/Desktop/quartile-ranking/td-p/560850
Regards,
Harsh Nathani
Anonymous , I do not see any qtr in data.
Typically when I do not have the date, Try to add a date and try to use date table and time intelligence. Else I move time-related data to a new table. Create a rank and do it.
Using Rank
uning Time Intelligence 2
https://medium.com/@amitchandak.1978/power-bi-qtd-questions-time-intelligence-2-5-d842063da839
Creating date when Date is not there
Within first few mins -https://www.youtube.com/watch?v=yPQ9UV37LOU&t=28s