In this example, I showcase how you can quite easily calculate the median value in Power BI.
I run through the MEDIANX function and how by using a virtual table within this function you can find the median for virtually anything.
All the best
Sam
*****Video Details*****
0:16 - Introduction
1:47 - Calculating Median Sales Using MEDIANX
3:29 - Another Way To Use The Formula
4:25 - Conclusion
***** Learning Power BI? *****
FREE COURSE - Ultimate Beginners Guide To Power BI - http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE - Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE - 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-reference-guide-download
FREE - Power BI Resources - http://enterprisedna.co/power-bi-resources
Enterprise DNA Membership - https://enterprisedna.co/membership
Enterprise DNA Online - http://portal.enterprisedna.co/
Enterprise DNA Events - https://enterprisedna.co/enterprise-dna-events-page/
***** Related Links *****
Iterating Functions In DAX Language – A Detailed Example
https://blog.enterprisedna.co/advanced-logic-within-dax-iterating-functions-detailed-example/
Virtual Tables Inside Iterating Functions In Power BI – DAX Concepts
https://blog.enterprisedna.co/how-to-understand-virtual-tables-inside-iterating-function-in-power-bi-dax-concepts/
Master Virtual Tables In Power BI Using DAX
https://blog.enterprisedna.co/working-with-virtual-in-memory-tables-in-power-bi-using-dax/
***** Related Course Modules *****
DAX Formula Deep Dives
http://portal.enterprisedna.co/p/dax-formula-deep-dives
Mastering DAX Calculations
http://portal.enterprisedna.co/p/mastering-dax-calculations
Learning Summit Series
http://portal.enterprisedna.co/p/learning-summit-series
***** Related Support Forums *****
Median Of A Time Column
https://forum.enterprisedna.co/t/median-of-a-time-column/1772
Calculating Median vs Alternate Percentile Ranks
https://forum.enterprisedna.co/t/calculating-median-vs-alternate-percentile-ranks/968
Measure To Calculate Median Sale Price
https://forum.enterprisedna.co/t/measure-to-calculate-median-sale-price/2128
For more median queries to review see here…..
https://forum.enterprisedna.co/search?q=MEDIAN
