DAX Commands and Tips

Join the discussion


Calendar Table returning error: The expression spe... by Previsible on ‎12-30-2024 01:35 PM Latest post on ‎01-02-2025 08:37 AM by Previsible 10 Replies 817 Views	10 Replies	817 Views
Same Period Last Year with Filter by BrianNeedsHelp on ‎10-31-2024 10:47 AM Latest post on ‎10-31-2024 06:25 PM by BrianNeedsHelp 10 Replies 612 Views	10 Replies	612 Views
Filter a Line Chart via DAX Measure to report ONLY... by garynorcrossmmc on ‎06-03-2024 01:38 PM Latest post on ‎06-18-2024 12:09 AM by v-shex-msft 3 Replies 298 Views	3 Replies	298 Views
MAX DAX Function giving incorrect sum by gamer_77768 on ‎04-06-2024 10:40 AM Latest post on ‎04-07-2024 05:50 AM by Greg_Deckler 2 Replies 396 Views	2 Replies	396 Views
MAX Date with Filters by kballar1 on ‎01-11-2024 07:40 AM Latest post on ‎01-11-2024 12:06 PM by kballar1 3 Replies 420 Views	3 Replies	420 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
Get Last Month Data thru DAX by Anonymous on ‎08-31-2016 12:12 AM Latest post on ‎08-26-2023 02:18 PM by technolog 1 Reply 2151 Views	1 Reply	2151 Views
How to get sum of sales from Max weeks in a quarte... by AudiencesQuesti on ‎08-17-2023 11:09 AM Latest post on ‎08-17-2023 11:23 AM by Greg_Deckler 1 Reply 289 Views	1 Reply	289 Views
Highlight cell if value is .3 higher than next hig... by uxorise3424 on ‎06-08-2023 12:52 PM Latest post on ‎06-09-2023 06:22 PM by lbendlin 1 Reply 280 Views	1 Reply	280 Views
DAX formula resulting in the currency code for whi... by PshemekFLK on ‎05-31-2023 03:01 AM Latest post on ‎05-31-2023 03:54 AM by PshemekFLK 7 Replies 827 Views	7 Replies	827 Views
DAX to return the max value for each customer by BenHoward on ‎05-10-2023 01:55 AM Latest post on ‎05-10-2023 02:05 AM by AntrikshSharma 1 Reply 656 Views	1 Reply	656 Views
MAX value from filtered matrix column and ranking by alex_gkk on ‎04-14-2023 06:20 AM Latest post on ‎04-24-2023 05:44 AM by alex_gkk 6 Replies 1634 Views	6 Replies	1634 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
Highest value of a duplicate by Lm2712 on ‎04-06-2023 12:11 PM Latest post on ‎04-06-2023 12:45 PM by Ajendra 2 Replies 875 Views	2 Replies	875 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
Max of a filtered measure by rrhutch on ‎02-22-2023 11:51 AM Latest post on ‎02-28-2023 06:40 PM by rrhutch 4 Replies 751 Views	4 Replies	751 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
Show top category per year on time chart by emdnz on ‎01-19-2023 06:18 PM Latest post on ‎01-22-2023 01:40 AM by parry2k 5 Replies 1772 Views	5 Replies	1772 Views
Max per category dependent on filter by Anonymous on ‎01-11-2023 08:31 AM Latest post on ‎01-12-2023 01:01 AM by Anonymous 7 Replies 789 Views	7 Replies	789 Views
Max Function Aggregate by Altonga on ‎01-05-2023 05:55 AM Latest post on ‎01-05-2023 07:42 AM by tamerj1 6 Replies 704 Views	6 Replies	704 Views
Computing a sum that depends on the max of other c... by areiasfi on ‎12-21-2022 01:56 PM Latest post on ‎12-22-2022 04:12 AM by Jihwan_Kim 3 Replies 304 Views	3 Replies	304 Views
DAX HELP WITH MAX WITH FEW CONDITIONS by Sridharkrish on ‎12-12-2022 10:54 PM Latest post on ‎12-13-2022 03:28 AM by Sridharkrish 8 Replies 616 Views	8 Replies	616 Views
Max of a measure for each ID by Anonymous on ‎12-07-2022 11:00 PM Latest post on ‎12-08-2022 10:09 PM by v-rzhou-msft 4 Replies 658 Views	4 Replies	658 Views
Get Max of a column grouping by another columns by sar7aan on ‎11-14-2022 01:55 AM Latest post on ‎11-22-2022 06:02 PM by v-xiaosun-msft 5 Replies 4338 Views	5 Replies	4338 Views
Night shift (logic, calculation) by Krivger on ‎11-11-2022 02:35 AM Latest post on ‎11-16-2022 05:27 AM by Krivger 2 Replies 520 Views	2 Replies	520 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 Multiple Criteria by PBInewbie17 on ‎10-19-2022 12:54 PM Latest post on ‎10-19-2022 04:07 PM by PBInewbie17 2 Replies 2174 Views	2 Replies	2174 Views
Struggling with MAX by ecfrench on ‎09-16-2022 10:36 AM Latest post on ‎09-27-2022 12:44 PM by ecfrench 8 Replies 679 Views	8 Replies	679 Views
Highest value of duplicate by Anonymous on ‎02-25-2021 04:59 AM Latest post on ‎09-02-2022 05:22 PM by Nathaniel_C 3 Replies 2625 Views	3 Replies	2625 Views
Count of Projects from Min Stage to Max Stage Disp... by Anonymous on ‎08-25-2022 10:23 AM Latest post on ‎08-31-2022 10:45 AM by Anonymous 6 Replies 547 Views	6 Replies	547 Views