Join the discussion

Help needed with some DAX calculations

by Latest post by

1 Reply 82 Views

1 Reply

82 Views

How to write a DAX query to display the subcategor...

by Latest post by

3 Replies 141 Views

3 Replies

141 Views

DAX to calculate relative and total percentage gro...

by on Latest post on by

2 Replies 136 Views

2 Replies

136 Views

Query IDs from previous quarter

by on Latest post on by

8 Replies 206 Views

8 Replies

206 Views

filling missing dates in dataset

by on Latest post on by

4 Replies 134 Views

4 Replies

134 Views

Compare two columns of a table and create a derive...

by on Latest post on by

4 Replies 218 Views

4 Replies

218 Views

Count Created row and removed row compared with pe...

by on Latest post on by

3 Replies 104 Views

3 Replies

104 Views

Override date filter in Power BI with months befor...

by on Latest post on by

2 Replies 107 Views

2 Replies

107 Views

Measure to get the earliest last date

by on Latest post on by

2 Replies 150 Views

2 Replies

150 Views

Sum based on column (different grannularities)

by on Latest post on by

4 Replies 140 Views

4 Replies

140 Views

Measure based on different filters

by on Latest post on by

3 Replies 160 Views

3 Replies

160 Views

DAX to fetch values from a column based on filter ...

by on Latest post on by

1 Reply 71 Views

1 Reply

71 Views

Helpful resources

DAX 1,028
Need Help 511
DAX Calculation 203
Measures 130
Filter 100
help 85
measure 77
Need Help DAX 75
CALCULATE 72
Dax Help 63
Power BI 58
Help Requested 51
Need Help DAX measure 49
Date 45
DAX Query 45
COUNT 45
Help me please 41
RANKX 39
DAX filter formula 38
Tips and Tricks 37
Time Intelligence 34
Help required 34
DAX Commands and Tips 32
Help with DAX 31
POWER BI Dax rules 31
Table 30
DAX Commands 29
Calculated columns 29
SUMMARIZE 28
sum 28
average 27
Help me 25
Slicer 23
dax measure 22
Show and Tell 21
if statement 21
TopN 20
Filtering 20
dates 20
Filters 19
if 19
Help with DAX Measure 18
Matrix Visual 18
Conditional Formatting 17
Power Query 17
Formula 17
DATEDIFF 17
Date and Time 17
PowerBI Desktop 15
LOOKUPVALUE 15
running total 15
percentage 14
Power BI Dax 14
Distinct 14
dax functions 14
DATEADD 14
YTD 14
help needed 14
distinctcount 14
Desktop 14
sumx 13
divide 13
DAX. CALCULATE 13
calculated column 13
Get Help 13
ranking 13
powerbi 13
hierarchy 12
ALLSELECTED 12
RLS 12
values 12
DAX function 12
matrix 12
Calculatetable 12
SELECTEDVALUE 12
ALLEXCEPT 12
DAX Measures 12
Max 12
all 12
help in dax Function 11
DAX For Filter 11
Switch() 11
Distinct Counts 11
switch 10
Month 10
if condition 10
Filter context 10
Measure Column Total 10
VAR 9
@NeedHelp 9
datesbetween 9
averagex 9
time functions 9
Compare 9
DAX Filtering 9
Dax commands help 9
COUNTROWS 9
groupby 9
tables 9
rank 9
Dynamic Date Period 9
Related Tables 9
Date measures to filter data. 9
DAX ALL PowerBI Excel 8
average of a measure 8
DAX Time Intelligence 8
USERELATIONSHIP 8
Year 8
columns 8
MAXX 8
Tutorial Requests 8
column calculation 8
Difference 8
Cumulative Sum 8
EARLIER 7
variables 7
crossjoin 7
General 7
slicers 7
Aggregation 7
cumulative 7
Matrix Visualisation 7
value 7
DAX Direct Query 7
Interesting Links 7
Power Pivot 7
time 7
column 7
Data Modeling 7
measure based on slicer 7
KPI 7
needhelp 7
SUMIF 6
Urgent Help 6
Need Help - Goals 6
blank 6
Cumulative Totals 6
Calculations 6
total 6
TOTALYTD 6
Virtual Table 6
calculation groups 6
currency conversion 6
@Please Help 6
index 6
join 6
CountIfs 6
Help appreciated 6
Table Visual 6
min 6
All() 6
Top N 6
Tip & Tricks 6
subtract filtered value 5
today 5
context 5
SQL 5
DAX RANKX 5
SUMMARIZECOLUMNS 5
datesinperiod 5
pareto 5
MAX date 5
Many to Many Relatioinship 5
dax formula 5
card 5
QTD 5
calculated table 5
rolling 12 5
Visual 5
POWER BI DATA VİEW 5
Group By 5
@Dax 5
Direct Query 5
Totals 5
percentages 5
Need Info 5
MTD 5
change 5
CONTAINS 5
SAME PERIOD LAST YEAR 5
Urgent Help with DAX 5
DAX BUG 5
Tips 5
AND 5
cumulative value 4
Search 4
Dynamic 4
Average Grand Total 4
Switch Metric 4
DAX Data Table 4
Slicer Visualizations 4
SQL to DAX 4
subtotals 4
Power BI Desktop 4
Format 4
minx 4
dynamic table 4
Date Table 4
optimize 4
group 4
chart 4
Formatting 4
keepfilters 4
@dax @help 4
Performance 4
averages 4
column selection 4
budget 4
Summary 4
Filter Multiple Column 4
crossfilter 4
weekly-averages 4
rows 4
VLOOKUP 4
PowerBI Community 4
REMOVEFILTERS 4
isfiltered 4
CONCATENATEX 4
Variable calculation 4
forecast 4
variable 4
sumifs 4
dates table 4
Measures to filter out 4
grouping 4
rolling 4
Text 4
Sumx() 4
Dax studio 4
lookup 4
date slicer 4
LASTNONBLANK 4
Year over Year 4
COUNTX 4
dax tip 4
SSAS 4
tabular 4
conditional 4
Variances 3
FILTERS DAX KEEPFILTERS 3
COUNTIF 3
calculated rows 3
Field Value 3
bar charts 3
Filter based on context 3
Rankx with filter 3
metrics 3
dax mode count 3
Merge 3
context filter 3
Cumulative Totals by category 3
Last date 3
Row Level Security 3
tutorials 3
Waterfall Chart 3
subtotal 3
PowerBI Help 3
Circular dependency 3
Excel 3
query 3
color 3
Dax Join 3
running balance 3
hasonevalue 3
weighted averages 3
what if parameters 3
firstdate 3
Need help (Using direct query) 3
DAX SWITCH 3
rolling dates 3
Weekday 3
General Question 3
Need Help re Measure Formatting 3
snapshot 3
Visualization 3
Calc column assistance 3
INACTIVE RELATIONSHIP 3
M Query 3
bar chart 3
Last Year 3
IF ELSE 3
Pareto Chart and table by Period help 3
Need Assistance 3
SLA 3
Line chart 3
condition 3
Loop 3
multiple rows 3
Data Protection 3
Running Totals 3
Standard Deviation 3
selected values 3
range of text 3
@need help 3
calendar 3
CUMULATIVE COUNT 3
Calander 3
Visual Filtering 3
Slicer based on calculated Measure 3
distribution 3
ID 3
date interval 3
SSAS Tabular 3
line graph 3
Unique Value 3
multiple column 3
union 3
Dashboard 3
Conversion 3
M 3
related 3
Performance Issues 3
previous year 3
relatedtable 3
WEEKNUM 3
function 3
Optimizing DAX 3
date calculation 3
Report 3
PBI Desktop 3
SUM of Units 3
FIFO 2
variance 2
sales 2
day 2
DAX tips 2
combine 2
Managing Roles 2
Analysis 2
Data Modelling 2
Stock Valuation 2
SVG 2
help with date 2
Calculate function with multiple criteria 2
Calculated Measures Only 2
DAX Max Date within date range 2
expression 2
guidelines 2
Query Editor 2
Reporting 2
Visualisations 2
Regression 2
Median 2
Age 2
previous 2
Retention 2
"aggregations" 2
30 2
Userrelationship 2
Iterator 2
weighted 2
Moving average 2
partial 2
BINS 2
Groups 2
calculation 2
Count rows (date) by month 2
segmentation 2
exclude 2
concatenate 2
relations 2
holidays 2
Month on Month Rank Comparison 2
blanks 2
measures in calculated columns 2
LastDate 2
New Help 2
Composite Model 2
drill 2
cumulative sum by category 2
sort formula 2
@Dax Measure Error 2
Countdistinct 2
recursive 2
previous week 2
Security roles 2
beginner 2
negative 2
aggregate 2
Advanced filtering 2
Groupings 2
cummulative dax 2
CALENDAR() 2
Analysis Service 2
Azure Analysis services tabular model 2
selection 2
while 2
date ranges 2
weighted distinct count 2
count distinct with condition 2
multiple date tables 2
custom formula 2
unpivot 2
grand total row incorrect 2
cohort 2
syntax 2
Max date from select dates in Dataset 2
tutorial request 2
NOT 2
New Challenge 2
Forecasting 2
yoy 2
percentile 2
Power BI Help 2
searching from 2 tables 2
Need Hepl 2
M language 2
Total Sum 2
Custom Filter 2
Last 2
DAX Language 2
Visuals 2
e 2
complex 2
cumulative percentage 2
OR function 2
relationships 2
Calculatetable filter 2
drillthrough 2
unique 2
DAX for max utilisation 2
% 2
sumtotal 2
Ignore Slicers 2
Week time intelligence 2
DAX Hierarchy 2
pivot table 2
fiscal 2
Row 2
DAX Syntax 2
categorization 2
dynamic filter 2
date format 2
In 2
grand total 2
tricks and tips 2
Rolling Months 2
Search table columns for similair data 2
Direct Query mode 2
grouped 2
commands 2
SUM based on existing context created by a measure 2
update 2
analysis services 2
mdx 2
calculated tables 2
employee 2
Multiplying by Sum 2
Summerizecolumn 2
New Table creation 2
cummulative 2
available 2
row context 2
General Comment 2
i 2
Please help 2
Previous month 2
date range 2
multiple tables 2
sorting 2
SUM of MAX 2
Moving average for measures 2
date filter 2
segment 2
Duplicate data 2
column total 2
duration 2
Events in progress 2
addcolumn 2
date hierarchy 2
Workday 2
conditional column 2
Concatenate columns in a measure 2
How To 2
Power 2
Desktop version 2
Total wrong in matrix 2
Categories 2
Dynamic data selection based on date 2
custom column 2
COUNTA 2
Quarter over Quarter 2
Tips & Tricks 2
timeline 2
benchmark 2
Assigning Roles 1
Parameter formatting 1
Advanced Visualization 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
running 1
optimised 1
Non Calendar FY and FQ 1
Previous Week comparison 1
sum vs target 1
working days 1
Case statement 1
NBA 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
Management 1
Azure 1
Roles 1
key 1
Scheduling 1
relative date filtering 1
default 1
Format Date 1
Region 1
scatterplot 1
IFNA excel funation alternative 1
levels 1
% complete 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
hide 1
HASONEFILTER 1
SEQUENCE 1
Unique Measure. 1
Button 1
multiple filters 1
Subtract 1
cardinality 1
Basket 1
Runnig Total 1
dynamic field 1
DATESMTD() 1
DATATABLE 1
cumulative distinct count 1
Security 1
Maximum number of values 1
Scorecard 1
Urgent 1
refresh data 1
graphs 1
.DAX 1
Capital Gain 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
POPL 1
DAX formula for tracking daily death cases 1
Merge files 1
sort 1
Help to Create Dax: applying filter for both Data Type(Text and Date) 1
TOTALMTD 1
record 1
Time Range 1
unix 1
Time interval 1
summarize table 1
Questions 1
TopN Customer 1
error 1
target 1
Icons 1
FX 1
Margin 1
Share Valuation 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
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
List value account 1
Running Total Weekly 1
time-intelligence 1
DAV 1
related table 1
Load Time 1
order time 1
sum duplicate dates 1
Load Graphs 1
Power BI Service 1
Financial 1
gauges 1
to 1
power bi visuals 1
Hierarchy slicer 1
Exchange 1
Cumulative sum partition 1
Stock In Hand 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
Combine Values 1
Tag rows 1
time format 1
Current Year VS Last Year 1
Networkdays 1
simulation 1
Parameter Data Type 1
month-to-date 1
Cumulative Total 1
STARTOFMONTH 1
attrition 1
Disconnected tables 1
Resource Use 1
Model 1
Google Analytics 1
Issue 1
data refresh 1
transpose 1
counts 1
CSV 1
Calendars 1
Mean Time Between Failure 1
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
conditional columns 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
12 hour 1
Start and end period 1
true () 1
i need help 1
invoice 1
Navigation 1
Trend Line 1
NoData 1
Days 1
iteration 1
DAX Relationships 1
Rate of Production 1
finance 1
queries 1
Dynamic RLS 1
Live Connection 1
timeline slicer 1
text filter 1
Power KPI Matrix 1
ALLCROSSFILTERED 1
two tables 1
Match 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
Data Type 1
Year to date 1
Row Number in DAX 1
90 1
work load 1
customer concentration 1
conditonal formatting 1
rowlevelsecurity 1
@stock_managment 1
one slicer to filter another table 1
24 hour 1
visual filter 1
Minimum AVG 1
isinscope 1
Intersect 1
ADDCOLUMNS() 1
Last N Months Data 1
KEEP 1
Tip 1
Months between 1
PowerQuery 1
Salesforce 1
Pricing 1
parameter 1
Query String 1
Python 1
range 1
loop up values from 2 tables 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
Average Sales 1
Group By For Two Columns in Dax 1
Window Function 1
NewBusiness 1
volume concentration 1
Delimiters 1
perce 1
@inventory @DAX 1
relationship 1
change format 1
filter by date hierarchy 1
@get help 1
SCD2 1
Quarter Issue 1
busqueda rangos 1
Meausre 1
Sample 1
contract 1
TREATAS 1
survey 1
Scheduled data refresh 1
metric 1
Expertise help 1
funnel plots 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
change time format 1
revenue 1
DATEADD Visit Windows 1
slicer calculation 1
Average from Matrix 1
rangos 1
first per day 1
Advanced 1
interaction 1
dax problem 1
Dinamyc index 1
Education 1
BUG 1
Embed Report 1
weekly 1
What If 1
multiple 1
conditions 1
TOTALYTD through Today 1
changing classifications 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
WTD 1
times 1
country 1
actuals 1
exponent 1
ratio calculations dax 1
weeks 1
help measure 1
Conteo 1
maxium 1
dax calculations 1
DAX help needed 1
page filters 1
community 1
Premium 1
DirectQuery 1
Fiscal Year 1
automation 1
scheduled 1
running-totals 1
Like for like pricing analysis 1
Floriankx 1
Visualizations 1
Unhandled 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
Average x month-13 1
display 1
filtrar 1
static value 1
@Greg_Deckler @Mich_J @amitchandak 1
repurchase 1
unico 1
Pareto Chart 1
max several rows 1
DatesMTD 1
Future Dates 1
append 1
quetsion 1
node 1
duplicate 1
many to many relationship issue 1
kcantor 1
pie chart tree 1
Grouped field 1
by 1
Roleplaying 1
select all 1
DAX for deals added and slipped 1
calculate Percentile 1
Atingir Meta e Solver 1
Except 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
conditional format 1
Rolling inventory in each month associated with SKU 1
@countifs functionality @Need Helop 1
Maxdate 1
relative date slicer 1
capacity 1
isnonblank 1
hour 1
Transliteration 1
by count 1
recruiting 1
@time 1
Fact 1
apply 1
Custom Visual 1
R 1
data 1
Active Directory 1
Gantt chart 1
tooltips 1
wildcard 1
Nee dhelp 1
iamprajot 1
where 1
automatic 1
Icon Formatting 1
Counter 1
comparison 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
YoY Line Charts 1
font colour 1
scalar 1
verting H 1
many to many 1
org chart 1
firstnonblank 1
filtro de tiempo 1
completed 1
DAX table filter 1
new user 1
transform 1
by group 1
Duplicates 1
count of consecutive days 1
@related @tables @relations 1
FPY 1
l 1
correlation 1
Gantt 1
Dynamics 365 1
stacked bar 1
pivot 1
imported 1
ovetteabejuela 1
Forex 1
New customers 1
Measure Multiplication 1
side by side 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
Substract with a measure 1
return 1
scenario 1
show statusRDP 1
@Ranks with Trend 1
color palette 1
returns 1
hex 1
if and else 1
with filters 1
filter context intersection 1
Table cell background color 1
"beginner asks Help" 1
Inventory 1
quota 1
Alias on summ 1
dax calculated 1
Rowtotal 1
QTR 1
Comparing columns 1
"LOOKUP" "DATA" "PERIOD" "INTERVAL" "BETWEEN" "SELECT" "FILTER" "TABLE" 1
FirstPass 1
Data model 1
s 1
live dashboards 1
themes 1
drill through 1
Streaming Datasets 1
need 1
formating 1
WOW 1
v-qiuyu-msft 1
inner join 1
last quarter 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
Rolling 12 Months 1
fiscal period 1
file name 1
DAX Performace 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
Monthly percentages 1
EarlierFunction 1
background color 1
New quick measure 1
Customer Revenue Comparison 1
Overlapping tables 1
math 1
Mongodb 1
VAT 1
comapring 1
Power M Query 1
webpagelinking 1
not null 1
Design 1
SharePoint 1
Map 1
Subscription 1
evaluation 1
Data Source 1
numbers 1
Combo Chart Report Server 1
normalize 1
row_number 1
Company Average 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
countblank 1
Bin 1
Conditional Formation Icons 1
14 day 1
Overlap 1
newbie 1
predictive models 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
Embed 1
Dynamic Column 1
date slicers 1
Memory 1
Quarter 1
sharepoint online 1
Sum on a dynamic date range 1