DAX Commands and Tips

Join the discussion


Fill in blanks with last non blank value (using DA... by Anonymous on ‎11-27-2019 04:26 PM Latest post on ‎01-22-2025 10:23 PM by dribblekeo 12 Replies 22194 Views	12 Replies	22194 Views
Calculating Commission on Sales by Yrstruly2021 on ‎05-27-2022 03:02 PM Latest post on ‎05-14-2024 10:50 AM by Hul001gp 2 Replies 919 Views	2 Replies	919 Views
DAX in building Rolling 4 Week Average by apatwal on ‎03-01-2022 10:01 AM Latest post on ‎03-28-2024 05:54 AM by stellasun820 5 Replies 4917 Views	5 Replies	4917 Views
Selectedmeasureformatstring DAX Calculation Item by MrRong on ‎02-02-2024 09:30 PM Latest post on ‎02-05-2024 03:44 AM by MrRong 6 Replies 999 Views	6 Replies	999 Views
DAX Polynomial Regression Calculation Issue by noah-severyn on ‎08-13-2021 01:52 PM Latest post on ‎01-29-2024 03:29 PM by ToddFEagle2023 8 Replies 4450 Views	8 Replies	4450 Views
Calculated column if date is within last 7 days us... by C-Jac on ‎02-22-2021 08:02 AM Latest post on ‎01-24-2024 03:33 AM by Muhammetmuslu 4 Replies 6481 Views	4 Replies	6481 Views
Calculate Max and Min value of subcategory within ... by praphull on ‎01-12-2024 04:05 AM Latest post on ‎01-15-2024 02:36 AM by praphull 2 Replies 306 Views	2 Replies	306 Views
cumulative count measure per row by lawadaa on ‎12-19-2023 11:28 PM Latest post on ‎12-28-2023 07:10 AM by sjoerdvn 2 Replies 355 Views	2 Replies	355 Views
Calculation 12 months slide by chloesouss on ‎11-23-2023 08:32 AM Latest post on ‎11-24-2023 06:57 PM by lbendlin 1 Reply 221 Views	1 Reply	221 Views
Looping and dynamically changing a table in DAX - ... by bklyn3 on ‎05-20-2022 02:57 PM Latest post on ‎10-08-2023 01:58 PM by Itsbibin 3 Replies 703 Views	3 Replies	703 Views
Calculate remaining capacity by Joynulali on ‎10-03-2023 03:59 PM Latest post on ‎10-05-2023 11:33 AM by Joynulali 2 Replies 335 Views	2 Replies	335 Views
Get the ranking base on category and month by Anonymous on ‎09-28-2023 11:16 AM Latest post on ‎09-30-2023 01:26 AM by 123abc 1 Reply 509 Views	1 Reply	509 Views
Summarize table Lookupvalue in Funnel Visual by gorgo on ‎06-19-2020 12:21 AM Latest post on ‎09-17-2023 10:00 AM by technolog 1 Reply 467 Views	1 Reply	467 Views
Dax formula for matching string values between dif... by kalkhudary on ‎08-25-2023 09:33 AM Latest post on ‎08-27-2023 08:15 PM by kalkhudary 6 Replies 750 Views	6 Replies	750 Views
Fill in blanks with last non blank value (using DA... by Anonymous on ‎11-18-2022 06:59 AM Latest post on ‎08-06-2023 11:46 PM by ThomasCo 6 Replies 803 Views	6 Replies	803 Views
Calculate Previous Month Total When Two Dates Are ... by InfiniteSheldon on ‎07-18-2023 03:39 PM Latest post on ‎07-19-2023 12:06 PM by InfiniteSheldon 4 Replies 499 Views	4 Replies	499 Views
help needed by akas2023 on ‎06-03-2023 02:30 PM Latest post on ‎06-01-2023 01:58 AM by Anonymous 5 Replies 1076 Views	5 Replies	1076 Views
Measure to calculate percentage by Jigar1276 on ‎05-24-2023 06:15 AM Latest post on ‎05-24-2023 10:15 PM by Jigar1276 2 Replies 643 Views	2 Replies	643 Views
Filter context doesnt apply with custom date slice... by MelvinM on ‎05-05-2023 12:52 PM 0 Replies 342 Views	0 Replies	342 Views
Calculate YTD and YTD-1 for the same period by AxelKAp on ‎10-19-2021 08:55 AM Latest post on ‎04-27-2023 07:25 AM by i26923 5 Replies 4623 Views	5 Replies	4623 Views
How to Calculate a Running Percentage Based on a P... by MStP on ‎11-10-2021 07:53 PM Latest post on ‎04-21-2023 04:18 AM by cmsouth 4 Replies 2307 Views	4 Replies	2307 Views
Same day Previous week DAX by Karthick_BI on ‎04-17-2023 12:09 AM 0 Replies 206 Views	0 Replies	206 Views
If or Switch statment based in percentage value by Ait-james on ‎08-29-2021 12:12 PM Latest post on ‎03-05-2023 05:56 PM by Venkata17 3 Replies 3044 Views	3 Replies	3044 Views
Display total of sum per year by GA1993 on ‎10-19-2021 01:02 PM Latest post on ‎02-21-2023 12:14 AM by mervemalli 8 Replies 13479 Views	8 Replies	13479 Views
Distinct Count de coluna virtual by Daniela_Romasko on ‎01-17-2023 05:03 AM Latest post on ‎01-17-2023 05:30 AM by tamerj1 1 Reply 426 Views	1 Reply	426 Views
Frequência de compra semanal by Daniela_Romasko on ‎01-12-2023 09:31 AM Latest post on ‎01-12-2023 07:29 PM by v-yangliu-msft 2 Replies 1069 Views	2 Replies	1069 Views
Rolling customers repeat purchase check in current... by shankarshiva on ‎12-02-2022 03:25 AM Latest post on ‎01-06-2023 12:05 AM by v-jianboli-msft 7 Replies 1090 Views	7 Replies	1090 Views
Calculation by Row by Year by Fantmas on ‎01-03-2023 02:33 AM Latest post on ‎01-03-2023 04:48 AM by Fantmas 3 Replies 460 Views	3 Replies	460 Views
C by Supanniga on ‎01-30-2023 07:14 PM Latest post on ‎12-28-2022 12:59 PM by CNENFRNL 1 Reply 653 Views	1 Reply	653 Views
Get % of Stacked Bar of Total For Each Bar by Anonymous on ‎12-22-2022 07:42 AM Latest post on ‎12-27-2022 11:46 PM by v-shex-msft 5 Replies 918 Views	5 Replies	918 Views