Join the discussion

Datediff from nonconsecutive rows, group by catego...

by Latest post by

3 Replies 125 Views

3 Replies

125 Views

Performance Tune Summarize function to GroupBy Fun...

by on Latest post on by

3 Replies 165 Views

3 Replies

165 Views

Evolution of value per id filtering by date

by on Latest post on by

6 Replies 269 Views

6 Replies

269 Views

Group By Sales rep and Max Count(Area)

by on Latest post on by

3 Replies 186 Views

3 Replies

186 Views

Calculate Planned and Worked hours by employee and...

by on Latest post on by

5 Replies 487 Views

5 Replies

487 Views

Group values together based on field value and cre...

by on Latest post on by

10 Replies 367 Views

10 Replies

367 Views

Group By For Two Columns in Dax

by on Latest post on by

2 Replies 160 Views

2 Replies

160 Views

Helpful resources

DAX 1,133
Need Help 559
DAX Calculation 218
Measures 144
Filter 110
Need Help DAX 98
help 93
measure 82
CALCULATE 76
Dax Help 67
Need Help DAX measure 66
Power BI 65
Help Requested 61
Date 48
Help me please 47
COUNT 46
DAX Query 45
RANKX 44
DAX Commands 41
DAX filter formula 38
Time Intelligence 37
DAX Commands and Tips 37
Tips and Tricks 37
Help required 36
Help with DAX 34
POWER BI Dax rules 33
Table 32
average 32
sum 32
Calculated columns 31
SUMMARIZE 30
Help me 27
Slicer 24
dax measure 22
dates 22
Show and Tell 22
Filtering 21
DATEDIFF 21
if statement 21
TopN 20
Power Query 20
DAX Measures 20
Filters 19
Matrix Visual 19
Conditional Formatting 19
Help with DAX Measure 19
if 19
Formula 19
Date and Time 18
running total 17
LOOKUPVALUE 16
Power BI Dax 16
PowerBI Desktop 16
Desktop 15
Switch() 15
help needed 15
@NeedHelp 15
Get Help 14
ranking 14
percentage 14
DATEADD 14
YTD 14
distinctcount 14
dax functions 14
sumx 14
Distinct 14
calculated column 14
@Dax 13
SELECTEDVALUE 13
Calculatetable 13
all 13
powerbi 13
divide 13
values 13
matrix 13
DAX. CALCULATE 13
ALLSELECTED 13
DAX function 12
Max 12
COUNTROWS 12
Distinct Counts 12
ALLEXCEPT 12
RLS 12
help in dax Function 12
hierarchy 12
switch 12
DAX For Filter 11
Month 11
Filter context 11
DAX Filtering 11
if condition 11
averagex 10
Compare 10
tables 10
Measure Column Total 10
Help appreciated 10
Cumulative Sum 10
average of a measure 9
USERELATIONSHIP 9
time functions 9
Virtual Table 9
@Please Help 9
Dax commands help 9
measure based on slicer 9
rank 9
Dynamic Date Period 9
Related Tables 9
Date measures to filter data. 9
VAR 9
Tutorial Requests 9
groupby 9
datesbetween 9
Matrix Visualisation 8
DAX Time Intelligence 8
Year 8
General 8
column 8
MAXX 8
column calculation 8
Difference 8
Aggregation 8
DAX ALL PowerBI Excel 8
columns 8
cumulative 8
time 7
KPI 7
value 7
DAX Direct Query 7
Group By 7
@dax @help 7
join 7
slicers 7
Table Visual 7
Cumulative Totals 7
All() 7
Interesting Links 7
Urgent Help 7
needhelp 7
Tip & Tricks 7
Power Pivot 7
EARLIER 7
variables 7
crossjoin 7
index 7
Data Modeling 7
Totals 7
calculated table 6
Need help (Using direct query) 6
total 6
TOTALYTD 6
Calculations 6
calculation groups 6
POWER BI DATA VİEW 6
Running Totals 6
currency conversion 6
percentages 6
CountIfs 6
Top N 6
SQL 6
min 6
Urgent Help with DAX 6
Direct Query 6
conditional 6
DAX RANKX 6
Visual 6
Need Help - Goals 6
SUMIF 6
blank 6
dax formula 5
Tips 5
lookup 5
rolling 12 5
Date Table 5
Need Info 5
date slicer 5
REMOVEFILTERS 5
Need Assistance 5
tabular 5
MTD 5
PowerBI Community 5
change 5
Measures to filter out 5
CONTAINS 5
grouping 5
SAME PERIOD LAST YEAR 5
DAX BUG 5
pareto 5
AND 5
subtract filtered value 5
today 5
context 5
SUMMARIZECOLUMNS 5
datesinperiod 5
SQL to DAX 5
Many to Many Relatioinship 5
PowerBI Help 5
Performance 5
MAX date 5
card 5
Variable calculation 5
QTD 5
Text 4
Visual Filtering 4
VLOOKUP 4
keepfilters 4
Tips & Tricks 4
Report 4
Last Year 4
forecast 4
averages 4
column selection 4
budget 4
Summary 4
Filter Multiple Column 4
weekly-averages 4
Loop 4
crossfilter 4
SSAS 4
isfiltered 4
Power BI Desktop 4
query 4
variable 4
sumifs 4
optimize 4
Dynamic 4
ID 4
dates table 4
rolling 4
@need help 4
Sumx() 4
Dax studio 4
multiple column 4
LASTNONBLANK 4
Year over Year 4
COUNTX 4
dax tip 4
Optimizing DAX 4
group 4
Format 4
Performance Issues 4
cumulative value 4
chart 4
Formatting 4
Search 4
Rankx with filter 4
Average Grand Total 4
DAX Data Table 4
Slicer Visualizations 4
Switch Metric 4
subtotals 4
CONCATENATEX 4
rows 4
dynamic table 4
minx 4
firstdate 3
DAX SWITCH 3
rolling dates 3
Weekday 3
General Question 3
Last date 3
Line chart 3
Calc column assistance 3
INACTIVE RELATIONSHIP 3
unpivot 3
Need Help re Measure Formatting 3
IF ELSE 3
Pareto Chart and table by Period help 3
recursive 3
condition 3
multiple rows 3
Data Protection 3
Standard Deviation 3
range of text 3
selected values 3
CUMULATIVE COUNT 3
Excel 3
Row Level Security 3
Rolling Months 3
Direct Query mode 3
Calander 3
PBI Desktop 3
Slicer based on calculated Measure 3
date interval 3
cummulative 3
row context 3
DAX Syntax 3
DAX help needed 3
line graph 3
multiple tables 3
Unique Value 3
union 3
duration 3
Conversion 3
M 3
related 3
color 3
relatedtable 3
WEEKNUM 3
function 3
snapshot 3
tutorials 3
SUM of Units 3
previous year 3
Variances 3
FILTERS DAX KEEPFILTERS 3
COUNTIF 3
date calculation 3
Quarter over Quarter 3
calculated rows 3
bar charts 3
Filter based on context 3
calendar 3
SLA 3
metrics 3
dax mode count 3
Field Value 3
Data Modelling 3
context filter 3
Cumulative Totals by category 3
distribution 3
M Query 3
Visualization 3
Waterfall Chart 3
Merge 3
concatenate 3
subtotal 3
Circular dependency 3
DAX tips 3
SSAS Tabular 3
bar chart 3
Dax Join 3
hasonevalue 3
weighted averages 3
Dashboard 3
what if parameters 3
running balance 3
aggregate 2
conditional columns 2
Advanced filtering 2
Countdistinct 2
How To 2
analysis services 2
dynamic filter 2
Visuals 2
Azure Analysis services tabular model 2
selection 2
while 2
negative 2
date ranges 2
weighted distinct count 2
count distinct with condition 2
multiple date tables 2
custom formula 2
Data Type 2
grand total row incorrect 2
Groupings 2
cummulative dax 2
i 2
mdx 2
date format 2
range 2
Max date from select dates in Dataset 2
Average Sales 2
CALENDAR() 2
Duplicate data 2
Please help 2
Gantt chart 2
calculated tables 2
Power BI Help 2
tutorial request 2
Need Hepl 2
M language 2
Total Sum 2
Custom Filter 2
Last 2
@get help 2
cohort 2
Days 2
e 2
complex 2
searching from 2 tables 2
OR function 2
relationships 2
DAX Language 2
NOT 2
Tip 2
syntax 2
Groups 2
calculation 2
guidelines 2
TOTALYTD through Today 2
cumulative percentage 2
% 2
sumtotal 2
Ignore Slicers 2
Week time intelligence 2
DAX Hierarchy 2
pivot table 2
fiscal 2
Calculatetable filter 2
TREATAS 2
Query Editor 2
column total 2
unique 2
DAX for max utilisation 2
grand total 2
tricks and tips 2
Search table columns for similair data 2
grouped 2
Except 2
commands 2
SUM based on existing context created by a measure 2
Row 2
Model 2
Reporting 2
Power 2
employee 2
In 2
Summerizecolumn 2
New Table creation 2
available 2
YoY Line Charts 2
page filters 2
timeline 2
Multiplying by Sum 2
date range 2
sorting 2
SUM of MAX 2
Substract with a measure 2
Moving average for measures 2
categorization 2
Visualisations 2
Previous month 2
addcolumn 2
Rolling 12 Months 2
fiscal period 2
date hierarchy 2
DAX Performace 2
Workday 2
conditional column 2
date filter 2
Sameperiodlastyear 2
previous week 2
Desktop version 2
normalize 2
Events in progress 2
Total wrong in matrix 2
Categories 2
Dynamic data selection based on date 2
custom column 2
COUNTA 2
Concatenate columns in a measure 2
evaluation context 2
New Challenge 2
New Help 2
Count rows (date) by month 2
benchmark 2
variance 2
sales 2
day 2
segment 2
dates between 2
drillthrough 2
Forecasting 2
Analysis Service 2
combine 2
FIFO 2
SVG 2
help with date 2
Calculate function with multiple criteria 2
Calculated Measures Only 2
DAX Max Date within date range 2
Regression 2
Median 2
Managing Roles 2
Analysis 2
Stock Valuation 2
previous 2
Retention 2
"aggregations" 2
30 2
Userrelationship 2
Iterator 2
Nead Help 2
update 2
Age 2
exclude 2
relations 2
holidays 2
Month on Month Rank Comparison 2
blanks 2
measures in calculated columns 2
LastDate 2
weighted 2
Moving average 2
General Comment 2
segmentation 2
drill 2
cumulative sum by category 2
sort formula 2
@Dax Measure Error 2
partial 2
BINS 2
Runnig Total 2
expression 2
yoy 2
percentile 2
Security roles 2
beginner 2
Composite Model 2
line chart visual 1
active customers 1
financial report 1
F 1
simple 1
Access Control 1
result 1
tooltip 1
ee 1
To Show Ratio 1:2 1
resets if 0 1
Hierarchy of Slicers 1
Top5 with Other column 1
deadline 1
tMonth 1
chart axis with no data 1
@ Matrix Visualisation Error In Calculation 1
Combine Values 1
Tag rows 1
time format 1
Current Year VS Last Year 1
Networkdays 1
List value account 1
Running Total Weekly 1
time-intelligence 1
record 1
Time Range 1
unix 1
Time interval 1
summarize table 1
Difference Between Dates 1
Tabular Model 1
DAX Division with Date 1
Design 1
data 1
Fiscal Year 1
ALLCROSSFILTERED 1
Mean Time Between Failure 1
timeline report 1
MoM 1
Null 1
dataype 1
add value from prior row measure 1
new measure of % by group 1
expand 1
"Calculation Group" 1
ALLSELECT SURVIVAL RATE 1
HR 1
Day of Week 1
semi-additive 1
Year to date 1
Row Number in DAX 1
90 1
work load 1
customer concentration 1
conditonal formatting 1
rowlevelsecurity 1
12 hour 1
Start and end period 1
true () 1
simulation 1
Parameter Data Type 1
month-to-date 1
DAV 1
related table 1
Load Time 1
order time 1
sum duplicate dates 1
Load Graphs 1
Deaths 1
XIRR 1
Suma del promedio 1
live dashboards 1
Active Directory 1
append 1
automation 1
Analytics 1
two tables 1
Match 1
last date time refresh 1
spend 1
Power BI report builder 1
Tableau 1
Lookupvalues 1
Help with DATESYTD DAX 1
transitive closure 1
in chosen periods 1
title 1
Please save me 1
Test as a Role 1
custom sorting 1
Help to update datasource 1
If Then 1
Turnover 1
Type 1
Group By For Two Columns in Dax 1
Window Function 1
NewBusiness 1
volume concentration 1
Delimiters 1
perce 1
@stock_managment 1
one slicer to filter another table 1
24 hour 1
visual filter 1
Minimum AVG 1
isinscope 1
i need help 1
invoice 1
Navigation 1
Cumulative Total 1
STARTOFMONTH 1
attrition 1
Disconnected tables 1
Resource Use 1
Previous row value 1
percentage of total column 1
unichar 1
Management 1
SharePoint 1
quetsion 1
multiple 1
metric 1
loop up values from 2 tables 1
Object level security 1
selected value 1
Dynamics CRM 1
I'm losing my mind 1
previousmonth 1
EARLIEST 1
Market Share 1
Technical question 1
have 1
cumulative sum by multiple criteria 1
dyanmic 1
First Value 1
LostBusiness 1
concentration curve 1
Every 1
Variation 1
@inventory @DAX 1
relationship 1
change format 1
filter by date hierarchy 1
SCD2 1
Intersect 1
ADDCOLUMNS() 1
Last N Months Data 1
Trend Line 1
NoData 1
iteration 1
DAX Relationships 1
Rate of Production 1
- B 1
Calculate dates 1
Drilldown help 1
Security 1
Embed 1
Map 1
Subscription 1
themes 1
drill through 1
Gantt 1
Dynamics 365 1
tooltips 1
scheduled 1
conditions 1
Expertise help 1
funnel plots 1
product function 1
Currency 1
sql_to_dax 1
one row 1
total zero 1
DATESYTD Help needed 1
ONE TABLE MODEL 1
yield 1
Ordered Vs Delivered 1
Custom calendar 1
Multiplication and wrong total in table 1
filter direction 1
Analysis Server 1
Find multiple values 1
utilization 1
Past & Current Month Latest data 1
Operator 1
opening balance 1
ReturningBusiness 1
customer percentage vs sales percentage 1
Dynamic Ranking 1
ISNUMBER 1
change time format 1
revenue 1
DATEADD Visit Windows 1
Quarter Issue 1
busqueda rangos 1
KEEP 1
Months between 1
PowerQuery 1
worngvalues 1
Summing Measures 1
stock 1
dv 1
Questions 1
Azure 1
Dynamic Column 1
evaluation 1
Data Source 1
Streaming Datasets 1
need 1
stacked bar 1
node 1
running-totals 1
Like for like pricing analysis 1
Floriankx 1
Visualizations 1
changing classifications 1
SPC DAX XMR chart Control limits 1
correct visuals 1
mailchimp 1
Cound IDs 1
Replace Text Based on Another Column 1
Bundle 1
usage metrics report 1
facts filtering dimensions 1
Line and stacked column chart 1
Lowest Market Share 1
Productivity 1
su 1
daily difference 1
category 1
multiple join 1
Dynamic Index 1
a da 1
WTD 1
times 1
country 1
actuals 1
exponent 1
slicer calculation 1
Average from Matrix 1
rangos 1
Meausre 1
Sample 1
contract 1
Total wrong 1
multiplication 1
match value 1
Thousand separator 1
Roles 1
PowerShell 1
numbers 1
formating 1
Visual Studio 1
duplicate 1
many to many relationship issue 1
kcantor 1
pie chart tree 1
Unhandled 1
by 1
Roleplaying 1
select all 1
DAX for deals added and slipped 1
calculate Percentile 1
Atingir Meta e Solver 1
Rebasing 1
Row Average 1
Column Chart 1
remote computers 1
Financial Year 1
able 1
Day on Day 1
Realtotals 1
new calculated table 1
consolidation 1
Report view 1
Average x month-13 1
display 1
filtrar 1
static value 1
ratio calculations dax 1
weeks 1
help measure 1
Report Data 1
first per day 1
Advanced 1
interaction 1
dax problem 1
Dinamyc index 1
IF THEN ELSE 1
rolling 12 month 1
overdue 1
number to text 1
Google Analytics 1
Power BI Service 1
TopN Customer 1
key 1
date slicers 1
wildcard 1
Nee dhelp 1
iamprajot 1
where 1
automatic 1
Grouped field 1
count 0 and 1 1
status change 1
delete rows 1
bad data 1
DAX com 1
like to get 1
fortnight 1
veryon 1
aaa 1
reference text 1
Total not matching 1
Top5 and Bottom 5 1
Week 1
Previous Month Last Year Card 1
compound 1
new calculated column 1
font colour 1
conditional format 1
Rolling inventory in each month associated with SKU 1
@countifs functionality @Need Helop 1
Maxdate 1
relative date slicer 1
@Greg_Deckler @Mich_J @amitchandak 1
repurchase 1
Conteo 1
maxium 1
dax calculations 1
non-zero 1
Score an account 1
ageing AP & AR 1
runningtotal 1
API 1
database 1
Scheduling 1
relative date filtering 1
Memory 1
pivot 1
imported 1
ovetteabejuela 1
Forex 1
New customers 1
Icon Formatting 1
Counter 1
comparison 1
evaluate total for a period for a specific column 1
stage change 1
Need to mark holidays in calendar 1
fill empy cell 1
COVID-19 1
Text Measure 1
return 1
scenario 1
show statusRDP 1
@Ranks with Trend 1
color palette 1
returns 1
hex 1
if and else 1
scalar 1
verting H 1
many to many 1
org chart 1
firstnonblank 1
filtro de tiempo 1
capacity 1
isnonblank 1
hour 1
unico 1
Pareto Chart 1
max several rows 1
DatesMTD 1
Future Dates 1
Previous YTD for Ranked Sales 1
Division 1
Multiple DAX switches and multiple slicers 1
large 1
Salesforce 1
finance 1
RankX issue with RLS 1
Financial 1
error 1
Maximum number of values 1
Scorecard 1
default 1
Format Date 1
WOW 1
v-qiuyu-msft 1
inner join 1
Measure Multiplication 1
side by side 1
ThreeYear Average 1
Absolute Value 1
opportunity stage 1
Cummulative Prev Change 1
Append measure to table 1
Match calculated ranking column 1
Circle diagram 1
Group total 1
TopN by Store 1
file name 1
BusinessCentral COA Totalling 1
remote desktop connection 1
Performance issues with AverageX 1
mailto 1
PRICE_NAME SUM(CALLS_SUM) AD 12 1
replace 1
DAX formulas for total quantity matching 1
with filters 1
filter context intersection 1
Table cell background color 1
"beginner asks Help" 1
Inventory 1
completed 1
DAX table filter 1
new user 1
Transliteration 1
by count 1
recruiting 1
@time 1
Fact 1
apply 1
leapyear 1
Week End Date Calculation 1
Filter using a measure 1
Tenure 1
survey 1
Pricing 1
Issue 1
target 1
Urgent 1
refresh data 1
Combo Chart Report Server 1
row_number 1
last quarter 1
LLY 1
one inn many 1
Summarize() 1
"average" 1
Dynamic Flag 1
INCORRECT CALENDAR 1
Line & Stacked Column 1
CODE 1
column percent 1
context transition 1
dynamic percentage calculation 1
Alternatives for AverageX 1
have a 1
subject line 1
741 ADM 14 1
annual 1
hI i 1
Path 1
Monthly percentages 1
EarlierFunction 1
background color 1
New quick measure 1
Power BI Admin 1
quota 1
Alias on summ 1
dax calculated 1
transform 1
by group 1
Duplicates 1
count of consecutive days 1
@related @tables @relations 1
FPY 1
@ 1
Running totals and cumulatives 1
SUMPRODUCT Measure 1
queries 1
data refresh 1
Quarter 1
sharepoint online 1
Sum on a dynamic date range 1
Company Average 1
BI Vs Tableau 1
not equal to 1
include 1
incorrect total 1
salary 1
Tutorial 1
10 1
Comcatenation 1
Filter two tables 1
ab 1
sclicer 1
Dinamic rows 1
Approximate Lookup Dates 1
totals calculation not correct in matrix 1
kpis 1
507 AE 990 AEDU 201 AEM 4 1
conditional replace 1
Parent 1
countblank 1
Bin 1
Conditional Formation Icons 1
Customer Revenue Comparison 1
Overlapping tables 1
math 1
Mongodb 1
Rowtotal 1
QTR 1
Comparing columns 1
"LOOKUP" "DATA" "PERIOD" "INTERVAL" "BETWEEN" "SELECT" "FILTER" "TABLE" 1
FirstPass 1
PARALLELPERIOD 1
cumulative count with independent date tables 1
community 1
Education 1
Dynamic RLS 1
gauges 1
to 1
Region 1
scatterplot 1
IFNA excel funation alternative 1
levels 1
Assigning Roles 1
Parameter formatting 1
Advanced Visualization 1
churn 1
subgroups 1
suggestions on Data Analysis 1
ORDER 1
empty columns 1
testing 1
Replace Values Based on Another Column 1
CD and CSD 1
query folding 1
20 1
coalesce 1
Selections 1
resource utilzation 1
growth rate 1
basket analysis 1
outbound delivery 1
395 AEMD 2 1
Weekly YOY 1
Combination Table 1
Child 1
running 1
optimised 1
Non Calendar FY and FQ 1
Previous Week comparison 1
14 day 1
Overlap 1
newbie 1
predictive models 1
VAT 1
comapring 1
Power M Query 1
webpagelinking 1
not null 1
sum of measure 1
Previous Quarter 1
Expanded Tables 1
parameter 1
Query String 1
Live Connection 1
timeline slicer 1
DAX FILTER 1
transpose 1
Missing data 1
% complete 1
change variables 1
pre 1
profit and loss 1
&& 1
ArcGIS Map 1
XLOOKUP 1
Error due to relationship 1
I need t 1
consecutive loss 1
Backlog 1
heed help on dax functions 1
RankX excluding Some Values 1
not display data 1
297 AF 36 AFME 2 AFMO 13 AFMW 9 AG 5 AGM 33 AGMD 23 AIMD 3 AIMF 2 AK 35 AL 82 ALMA 218 ALME 56 ALMV 854 AM 10 AMGG 1 AMGU 2 1
null value fields 1
Data Transformation 1
hide 1
HASONEFILTER 1
SEQUENCE 1
Unique Measure. 1
Button 1
sum vs target 1
working days 1
Case statement 1
NBA 1
For Loop 1
headcount when have FT and PT in department 1
Dynamic slicer flag column 1
Reverse Cumulative 1
weighted average 1
YYYY-YY 1
Needl Help 1
Roll 1
Custom Visual 1
BUG 1
Scheduled data refresh 1
text filter 1
counts 1
Icons 1
FX 1
Margin 1
graphs 1
.DAX 1
Capital Gain 1
" cumulatives" 1
dashboard dax help 1
maximum 1
credit 1
dependency 1
40 1
Likert scale 1
Nominator 1
Decomposition Tree 1
DAX CALENDARAUTO() 1
funnel 1
multiple dates 1
bell curve 1
POPL 1
DAX formula for tracking daily death cases 1
Merge files 1
sort 1
multiple filters 1
Subtract 1
cardinality 1
Basket 1
running a Query with two tables to show each row 1
Split column 1
DAX to Power M Query 1
change logs 1
hits 1
unique id 1
Past Due 1
COMBINEVALUE 1
l 1
R 1
Premium 1
Embed Report 1
weekly 1
Power KPI Matrix 1
power bi visuals 1
Hierarchy slicer 1
Exchange 1
Share Valuation 1
Transaction 1
numbertostring 1
Nonlinear Regression 1
Production 1
debit 1
Premium Capacity 1
Dimension 1
Work days 1
50 1
count of count 1
Denominator 1
expressions 1
stacked column chart 1
Integer 1
available time 1
List sorting 1
overlaying graph 1
POP&L 1
Flag 1
Error of Expression Refers to multiple columns. Multiple columns cannot be converted to scalar value 1
Margin Percentage 1
Add "IF" before calculate 1
Empty 1
Help to Create Dax: applying filter for both Data Type(Text and Date) 1
TOTALMTD 1
dynamic field 1
DATESMTD() 1
DATATABLE 1
cumulative distinct count 1
Missing Dates 1
Invoices 1
concatenate within SWITCH() 1
Data model 1
s 1
correlation 1
DirectQuery 1
What If 1
Python 1
CSV 1
Calendars 1
Cumulative sum partition 1
Stock In Hand 1