DAX Commands and Tips

Join the discussion

New Message

Subject

Replies

Views


shown last prev months filter by Vidya_1882 on ‎07-08-2024 04:56 AM Latest post on ‎07-08-2024 11:23 AM by foodd 2 Replies 217 Views	2 Replies	217 Views
Average in a matrix with hours and week days, resu... by thne123 on ‎07-08-2024 08:44 AM Latest post on ‎07-08-2024 10:07 AM by thne123 2 Replies 242 Views	2 Replies	242 Views
KPI Help by ArchStanton on ‎07-08-2024 08:28 AM Latest post on ‎07-08-2024 09:51 AM by ArchStanton 2 Replies 181 Views	2 Replies	181 Views
Carry current month total forward to plot future c... by MozTom on ‎07-08-2024 08:00 AM Latest post on ‎07-08-2024 09:39 AM by foodd 1 Reply 184 Views	1 Reply	184 Views
Matrix Visual: Required Average of Sub-Total in Gr... by ChinrajP on ‎07-08-2024 03:49 AM Latest post on ‎07-08-2024 09:39 AM by ChinrajP 9 Replies 505 Views	9 Replies	505 Views
YOY calculation by doubi1899 on ‎07-08-2024 01:29 AM Latest post on ‎07-08-2024 08:53 AM by doubi1899 4 Replies 304 Views	4 Replies	304 Views
Set value in string variable in multiple steps by EdjeVis on ‎07-08-2024 02:24 AM Latest post on ‎07-08-2024 08:44 AM by EdjeVis 7 Replies 392 Views	7 Replies	392 Views
Dynamic measures by ells69 on ‎07-06-2024 04:21 AM Latest post on ‎07-08-2024 07:34 AM by lbendlin 5 Replies 1154 Views	5 Replies	1154 Views
Rankx calculated column unexpected ranking discrep... by Joris_NL on ‎07-04-2024 03:57 AM Latest post on ‎07-08-2024 07:18 AM by lbendlin 5 Replies 575 Views	5 Replies	575 Views
Grouping, Binning or Analyze features are either d... by E12345 on ‎06-21-2024 02:45 PM Latest post on ‎07-08-2024 06:57 AM by E12345 3 Replies 428 Views	3 Replies	428 Views
Calculated Column that returns duplicate values by Tmk123 on ‎07-05-2024 01:32 PM Latest post on ‎07-08-2024 05:48 AM by Tmk123 2 Replies 284 Views	2 Replies	284 Views
how to return the selected value of slicer and add... by oakfootballclub on ‎07-08-2024 02:37 AM Latest post on ‎07-08-2024 05:41 AM by BeaBF 2 Replies 236 Views	2 Replies	236 Views
Summing up a Measure based on some consitions by samioberoi on ‎07-07-2024 10:26 AM Latest post on ‎07-08-2024 05:31 AM by BeaBF 2 Replies 283 Views	2 Replies	283 Views
Excel formula to Dax by Umesh1988 on ‎07-07-2024 10:42 AM Latest post on ‎07-08-2024 05:29 AM by BeaBF 2 Replies 1249 Views	2 Replies	1249 Views
LASTNONBLANKVALUE doesn't work with other date col... by bubbledep on ‎07-05-2024 09:51 AM Latest post on ‎07-08-2024 05:08 AM by bubbledep 10 Replies 821 Views	10 Replies	821 Views
Is there an alternative to Edate that calculates t... by ClemFandango on ‎07-04-2024 06:04 AM Latest post on ‎07-08-2024 04:54 AM by ClemFandango 10 Replies 1009 Views	10 Replies	1009 Views
Rank function on selected dates by llealsantos on ‎07-05-2024 09:33 AM Latest post on ‎07-08-2024 02:15 AM by llealsantos 6 Replies 475 Views	6 Replies	475 Views
Values in table disappear after adding new column ... by thefunmachine3 on ‎07-08-2024 01:41 AM Latest post on ‎07-08-2024 02:06 AM by foodd 3 Replies 350 Views	3 Replies	350 Views
Last 3 months average sales excluding current mont... by HY2024 on ‎07-04-2024 10:03 AM Latest post on ‎07-08-2024 02:03 AM by HY2024 10 Replies 540 Views	10 Replies	540 Views
Add column value if it doesn't exist by TAD80 on ‎07-01-2024 03:51 AM Latest post on ‎07-08-2024 01:51 AM by TAD80 3 Replies 350 Views	3 Replies	350 Views
YTD last year, until past week by Anonymous on ‎07-05-2024 06:36 AM Latest post on ‎07-08-2024 01:15 AM by v-jiewu-msft 2 Replies 328 Views	2 Replies	328 Views
Minutes worked per hour by Wesley1979 on ‎07-02-2024 02:17 AM Latest post on ‎07-08-2024 01:12 AM by Wesley1979 2 Replies 305 Views	2 Replies	305 Views
calculation between non consecutives rows by FelipeScheihing on ‎07-05-2024 03:56 PM Latest post on ‎07-08-2024 01:09 AM by v-linyulu-msft 2 Replies 243 Views	2 Replies	243 Views
Replacing SUMMARIZECOLUMNS with SUMMARIZE to get m... by MBZA on ‎07-01-2024 04:35 AM Latest post on ‎07-08-2024 01:09 AM by MBZA 4 Replies 304 Views	4 Replies	304 Views
How to get the values of the past year by FilipHanus on ‎06-20-2024 12:00 AM Latest post on ‎07-08-2024 01:06 AM by FilipHanus 12 Replies 501 Views	12 Replies	501 Views
sum amt when the filter date and the target date a... by miinseon on ‎07-07-2024 06:55 PM Latest post on ‎07-08-2024 12:35 AM by miinseon 6 Replies 359 Views	6 Replies	359 Views
IF Statement on MATRIX returns correct value at to... by GeorgeAiva on ‎06-28-2024 04:17 AM Latest post on ‎07-08-2024 12:29 AM by GeorgeAiva 7 Replies 539 Views	7 Replies	539 Views
CONCAT in a measure which should behave like a col... by Anonymous on ‎07-05-2024 07:06 AM Latest post on ‎07-08-2024 12:11 AM by Anonymous 2 Replies 233 Views	2 Replies	233 Views
Top 2 Contribution % calculation by TB2 on ‎07-07-2024 06:51 AM Latest post on ‎07-08-2024 12:08 AM by v-xingshen-msft 3 Replies 313 Views	3 Replies	313 Views
PowerBI total sum is incorrect by hushpuppies on ‎07-07-2024 07:19 PM Latest post on ‎07-08-2024 12:02 AM by v-fenling-msft 2 Replies 259 Views	2 Replies	259 Views

Helpful resources

Announcements

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

Learn more

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Unanswered Topics

Subject	Author	Posted
Benchmark Measure Still Affected by Slicer Despite...	user_guddu10	yesterday
dax expression help to calculate YTD Budgets with ...	ashmitp869	‎03-19-2024 05:36 PM
Dax expression with ignore Year and Month but incl...	ashmitp869	‎03-19-2024 02:53 PM
Rolling periods from 2 different date tables	CarlBlunck	‎02-29-2024 05:28 PM
Circular dependency Error	Nishant_Chawla	‎12-20-2023 01:01 AM

New solutions

Subject

Author

NEW! Community Notebooks Gallery

DAX Commands and Tips

Join the discussion

Helpful resources

Power BI Monthly Update - March 2025

Fabric Community Update - March 2025