DAX Commands and Tips

Join the discussion


Trying to Get a Max Rate for a Customer, filter th... by RRush on ‎01-06-2025 05:29 PM Latest post on ‎01-16-2025 05:48 AM by RRush 4 Replies 367 Views	4 Replies	367 Views
How can I return only the third highest/lowest cat... by dataaanana on ‎12-20-2023 06:20 AM Latest post on ‎12-24-2023 11:59 PM by v-tangjie-msft 3 Replies 391 Views	3 Replies	391 Views
How do i find a maximum value based on 2 columns? by WilliamKaro on ‎12-19-2023 02:07 AM Latest post on ‎12-19-2023 11:27 PM by Anonymous 1 Reply 280 Views	1 Reply	280 Views
Lowest/ Highest value by shayla on ‎12-04-2023 06:02 AM Latest post on ‎12-04-2023 07:04 AM by Dangar332 3 Replies 2141 Views	3 Replies	2141 Views
How to find the max of rows from 5 different colum... by Khushboo9966 on ‎10-10-2023 02:03 PM Latest post on ‎10-11-2023 07:05 AM by Khushboo9966 2 Replies 268 Views	2 Replies	268 Views
max measure is showing infinity value by lawadaa on ‎10-05-2023 01:11 PM Latest post on ‎10-05-2023 10:52 PM by ValtteriN 1 Reply 391 Views	1 Reply	391 Views
Remove Table Filters While Using Virtual Table Mea... by C_PriceOH on ‎09-01-2023 01:02 PM Latest post on ‎09-05-2023 06:55 AM by some_bih 3 Replies 384 Views	3 Replies	384 Views
Max date by group, rewrite measure to create calcu... by leolapa_br on ‎08-28-2023 01:12 PM Latest post on ‎08-28-2023 01:25 PM by leolapa_br 1 Reply 224 Views	1 Reply	224 Views
Create a Calculated Column using MAX value from an... by AvalBuroAdmin on ‎09-03-2020 12:50 PM Latest post on ‎07-26-2023 04:58 AM by sunnyzags 5 Replies 2106 Views	5 Replies	2106 Views
MAX DAY PER MONTH WITH A CONDITIONAL by CESARPULIDOGDL on ‎04-13-2023 09:29 PM Latest post on ‎04-17-2023 03:58 PM by CESARPULIDOGDL 2 Replies 534 Views	2 Replies	534 Views
DAX measure to return the Second largest true valu... by balafbm on ‎04-04-2023 06:10 AM Latest post on ‎04-04-2023 06:39 AM by tamerj1 1 Reply 413 Views	1 Reply	413 Views
MAXX function running slow - how to make it run fa... by dancarr22 on ‎04-03-2023 02:02 PM Latest post on ‎04-03-2023 04:26 PM by dancarr22 2 Replies 590 Views	2 Replies	590 Views
Using MAXX and filter with dates from date slicer by kristir2010 on ‎01-31-2023 11:53 AM Latest post on ‎01-31-2023 11:17 PM by v-rzhou-msft 1 Reply 541 Views	1 Reply	541 Views
Summarize a MAXX measure by Wokster on ‎01-24-2023 06:05 AM Latest post on ‎01-25-2023 08:34 AM by Wokster 4 Replies 559 Views	4 Replies	559 Views
Get a corresponding price from another table using... by Anonymous on ‎11-22-2022 04:38 AM Latest post on ‎11-22-2022 07:18 AM by Anonymous 2 Replies 1512 Views	2 Replies	1512 Views
Can't get to the right MAX by PshemekFLK on ‎10-27-2022 08:30 AM Latest post on ‎10-27-2022 03:00 PM by PshemekFLK 13 Replies 1049 Views	13 Replies	1049 Views
Filter is Excluding Days Needed in Cumulative Tota... by PBInewbie17 on ‎10-20-2022 07:30 AM Latest post on ‎10-26-2022 02:44 PM by PBInewbie17 2 Replies 516 Views	2 Replies	516 Views
Selecting the most recent row of data based on dat... by MarDen94 on ‎09-02-2022 12:02 AM Latest post on ‎09-05-2022 05:40 AM by MarDen94 5 Replies 619 Views	5 Replies	619 Views
Max Value based on two categories by alanbbarton on ‎07-13-2022 01:54 PM Latest post on ‎07-14-2022 08:47 AM by alanbbarton 2 Replies 388 Views	2 Replies	388 Views
Find max for each group of rows by gvlado on ‎07-01-2022 05:22 AM Latest post on ‎07-05-2022 03:23 AM by gvlado 3 Replies 2013 Views	3 Replies	2013 Views
Getting Values by MAXIMUM Alphabatic Letter for Di... by rifdhyh on ‎06-29-2022 10:23 PM Latest post on ‎07-01-2022 04:58 AM by rifdhyh 4 Replies 356 Views	4 Replies	356 Views
MAX Sales on a day and SKU level Sales by subzero355 on ‎06-08-2022 11:38 PM Latest post on ‎06-09-2022 06:59 AM by subzero355 8 Replies 1902 Views	8 Replies	1902 Views
MAXX and MINX calculating wrongly on measure by jmkvalsund on ‎02-04-2022 06:45 AM Latest post on ‎02-09-2022 04:36 AM by jmkvalsund 4 Replies 1217 Views	4 Replies	1217 Views
MAX Total Revenue On Card by armchairexpert on ‎01-18-2022 08:08 AM Latest post on ‎01-18-2022 08:52 AM by armchairexpert 2 Replies 474 Views	2 Replies	474 Views
Compairing a date measure to a date column in the ... by arc_gts on ‎12-29-2021 07:52 AM Latest post on ‎12-29-2021 05:25 PM by smpa01 7 Replies 1001 Views	7 Replies	1001 Views
MAXX - can't get off filter by janislv on ‎12-14-2021 08:27 AM Latest post on ‎12-14-2021 12:32 PM by janislv 2 Replies 404 Views	2 Replies	404 Views
Applying MAX to Summerize by AltGr9 on ‎11-11-2021 03:31 AM Latest post on ‎11-14-2021 06:46 PM by v-robertq-msft 7 Replies 947 Views	7 Replies	947 Views
Weighted Average between 2 calculate measures by PshemekFLK on ‎09-28-2021 06:02 AM Latest post on ‎09-28-2021 07:39 AM by PshemekFLK 2 Replies 382 Views	2 Replies	382 Views
Sum of maximal value for specific name by Maestro on ‎08-26-2021 08:22 AM Latest post on ‎09-01-2021 01:41 AM by VahidDM 3 Replies 530 Views	3 Replies	530 Views
DAX to show Total value by Month highlighting High... by Anonymous on ‎02-03-2021 04:49 AM Latest post on ‎02-03-2021 04:50 AM by Anonymous 2 Replies 450 Views	2 Replies	450 Views