first quartile
1 Topic
First Quartile calculation in Power BI
Hi , I have a dataset where i am calculating Energy Use Index and i want a card metric to calculate First Quartile of Energy Use Index. Please provide me a way to calculate it. I have location, area of the location and Energy Use Index is total energy consumption / total area and we have a year filter. Data Source is databricks and mode is Direct Query mode.Solved557Views0likes1Comment