![]() ![]() MINX( FILTER ( VALUES ( Table1 ),ĬOUNT( Table1 ) - 1 ) / 2 ), Table1)) / 2 Here is the DAX MEDIAN formula (line breaks have been added to help readability): =(ĬOUNT( Table1 ), Table1ĬOUNT( Table1 ) / 2 ), Table1) DAX is similar to the Excel formula language, but it has some different functions, and unlike Excel functions, DAX is case sensitive. Ok, let’s address the formula elephant in the room! I know that formula may look a little large, and maybe even daunting.įear not. I only have one table in my model, called Table1.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |