DAX Commands and Tips

Join the discussion

DistinctCount ONLY the lowest values of a column i...

by on Latest post on by

6 Replies 241 Views

6 Replies

241 Views

Filter and Replace values

by on Latest post on by

3 Replies 276 Views

3 Replies

276 Views

Count distinct start dates by item

by on Latest post on by

3 Replies 276 Views

3 Replies

276 Views

DistinctCount , ignoring one filter

by on Latest post on by

2 Replies 290 Views

2 Replies

290 Views

Distinct Count based on calculated percentage meas...

by on Latest post on by

3 Replies 380 Views

3 Replies

380 Views

Get column total and percent of column

by on Latest post on by

1 Reply 299 Views

1 Reply

299 Views

Correlate two separate date fields in Dax for %Res...

by on Latest post on by

3 Replies 467 Views

3 Replies

467 Views

DistinctCount shows 1 when it is 0

by on Latest post on by

3 Replies 577 Views

3 Replies

577 Views

Distinct Count Help

by on Latest post on by

4 Replies 443 Views

4 Replies

443 Views

DISTINCTCOUNT doesn't give correct result as a col...

by on Latest post on by

2 Replies 270 Views

2 Replies

270 Views

DISTINCTCOUNT based on measure

by on Latest post on by

2 Replies 467 Views

2 Replies

467 Views

DISTINCTCOUNT Optimization

by on Latest post on by

5 Replies 394 Views

5 Replies

394 Views

DAX - Average by sum of different values

by on Latest post on by

2 Replies 414 Views

2 Replies

414 Views

Calculating % of Patients Not Seen by Date

by on Latest post on by

3 Replies 323 Views

3 Replies

323 Views

Distinct Selection on two columns

by on Latest post on by

2 Replies 269 Views

2 Replies

269 Views

User filter doesn't apply on distinctcount

by on Latest post on by

3 Replies 296 Views

3 Replies

296 Views

Need help to calculate a measure based on another ...

by on Latest post on by

9 Replies 887 Views

9 Replies

887 Views

Count number of Customers, that only have one Reco...

by on Latest post on by

9 Replies 2297 Views

9 Replies

2297 Views

COUNT vs DISTINCTCOUNT for coverage calculations

by on Latest post on by

1 Reply 177 Views

1 Reply

177 Views

DistinctCount grouping by

by on Latest post on by

1 Reply 224 Views

1 Reply

224 Views

how to distinct count based on lower granularity t...

by on Latest post on by

2 Replies 763 Views

2 Replies

763 Views

Count Rows based on dynamic column value

by on Latest post on by

9 Replies 1629 Views

9 Replies

1629 Views

Coalesce replace Blank

by on Latest post on by

2 Replies 536 Views

2 Replies

536 Views

Distinct Count Two Measures

by on Latest post on by

8 Replies 1567 Views

8 Replies

1567 Views

Days since the device last synced measure (or colu...

by on Latest post on by

1 Reply 310 Views

1 Reply

310 Views

DistinctCount where Count > Than X

by on Latest post on by

4 Replies 734 Views

4 Replies

734 Views

DISTINCTCOUNT of items and sum by previous month

by on Latest post on by

1 Reply 1430 Views

1 Reply

1430 Views

Divide measure by distinct count

by on Latest post on by

1 Reply 586 Views

1 Reply

586 Views

Distinct count to find Attendance using multiple f...

by on Latest post on by

5 Replies 1565 Views

5 Replies

1565 Views

Beginner DAX syntax to combine unique count & anot...

by on Latest post on by

2 Replies 492 Views

2 Replies

492 Views

Helpful resources

DAX 3,859
Need Help 2,946
"DAX" 509
help 426
DAX Calculation 413
Need Help DAX 324
"Need Help" 323
Filter 321
Measures 291
"DAX help" 282
measure 275
Tips and Tricks 251
Help Requested 237
CALCULATE 229
Power BI 226
Show and Tell 217
Need Help DAX measure 190
DAX Commands and Tips 169
COUNT 151
Help appreciated 148
Help me please 147
Date 143
Dax Help 138
Help me 132
Slicer 132
@Dax 128
@Dax help 121
RANKX 111
DAX Measures 111
Tutorial Requests 110
SUMMARIZE 109
Help with DAX 105
DAX Commands 103
Help required 101
Help Request 95
"DAX " 93
powerbi 88
Time Intelligence 86
sum 85
average 84
"Help" 82
Table 77
@dax @help 76
Power Query 75
@Daxhelp 74
dates 74
@NeedHelp 71
DAX help needed 71
DAX Query 70
matrix 69
Calculated columns 68
POWER BI Dax rules 67
DATEDIFF 67
if 67
COUNTROWS 61
sumx 60
LOOKUPVALUE 59
"MEASURE" 59
Filters 56
Formula 54
TopN 52
Conditional Formatting 52
calculated column 51
"Calculated Column" 51
"CALCULATE" 51
Help with DAX Measure 49
"DAX Commands and Tips" 48
Matrix Visual 47
help needed 46
"Power BI" 46
"DAX " "DAX help" 'Need help' 'DAX' 46
Desktop 45
General Comment 45
Max 45
SELECTEDVALUE 43
DAX filter formula 42
Need Assistance 42
"FILTER" 42
dax measure 40
Power BI Dax 39
DAX Formulas 38
distinctcount 37
RLS 37
Get Help 37
ALLSELECTED 36
all 36
running total 36
Power BI Desktop 36
MAXX 35
percentage 35
Filtering 35
YTD 34
if statement 34
ALLEXCEPT 34
Distinct Counts 34
Filter context 34
divide 33
@Power BI 33
DATEADD 33
rank 33
switch 33
groupby 32
PowerBI Desktop 32
@Dax Measure Error 31
Group By 31
ranking 31
DAX Filtering 31
'Need help' 'DAX' 31
@Please Help 31
values 30
DAX ALL PowerBI Excel 30
Hierarchy 30
Running Totals 30
Distinct 29
@help 29
"beginner asks Help" 29
Switch() 29
slicers 29
DAX Power BI 29
USERELATIONSHIP 28
dax formula 28
column 28
Data Modeling 28
"dax code" 28
DAX Command 28
Cumulative Sum 27
Urgent Help with DAX 27
datesbetween 27
EARLIER 27
Virtual Table 26
Excel 26
needhelp 26
Aggregation 25
Visual 25
tables 25
Measure Column Total 25
All() 25
total 25
DAX FILTER 25
Compare 24
Tips & Tricks 24
"DAX help" DAX 24
SUMMARIZECOLUMNS 24
Dynamic 24
Calculatetable 24
REMOVEFILTERS 23
Power Pivot 23
Interesting Links 23
" Slicer" 23
Totals 22
DAX tips 22
calculated table 22
Data Protection 22
Calculated Measures 22
blank 22
relationships 21
DAX RANKX 21
calculation 21
variables 21
Date and Time 21
@need help 21
@measure 21
CONCATENATEX 21
VAR 21
Cumulative Total 21
error 20
DAX. CALCULATE 19
Format 19
time 19
Month 19
min 18
@Conditional Formatting 18
Urgent Help 18
MTD 18
Forecasting 18
lookup 18
averagex 18
calculation groups 18
average of a measure 17
Dax commands help 17
calendar 17
DAX Time Intelligence 17
Need Help -DAX Measures 17
chart 17
related 17
"Time Intelligence" 17
if condition 17
"RANKX" 17
cumulative 17
Formula Help 17
Need Dax 17
"Dates" 17
SQL 17
Top N 16
PowerBI Community 16
Circular dependency 16
Sameperiodlastyear 16
Line chart 16
card 16
Dax studio 16
index 16
Date Table 16
Field parameters 16
CONTAINS 16
MAX date 16
Tips 16
dax functions 16
duration 15
Need help (Using direct query) 15
DAX SUMMARIZE 15
Cumulative Calculation 15
COUNTX 15
value 15
Urgent 15
If statements 15
Need Help in Power Bi 15
forecast 15
SAME PERIOD LAST YEAR 15
conditional 15
Table Visual 15
"DAX" "Earliest date" 15
"DAX " "DAX help" 'Need help' 15
columns 15
Calculations 15
@powerbi 15
KPI 15
Running totals and cumulatives 15
Need Urgent Help 15
DAX Averages 14
Direct Query 14
Slicer Visualizations 14
Related Tables 14
DAX Direct Query 14
DAX SWITCH 14
help in dax Function 14
DAX For Filter 14
"CALCULATETABLE" 14
DAX function 14
crossfilter 14
POWER BI DATA VİEW 14
Need help with DAX 14
Matrix Visualisation 14
context 14
variable 13
Tutorial 13
CUMULATIVE COUNT 13
Cumulative Totals 13
@measure filter 13
"Date Table" 13
Date measures to filter data. 13
relationship 13
DAX BUG 13
Performance 13
PowerQuery 13
concatenate 13
Optimizing DAX 13
LASTNONBLANK 13
Difference 13
sort 13
Duplicates 13
Need DAX Help 13
AND 13
question 13
TOTALYTD 12
rows 12
minx 12
column calculation 12
weighted average 12
condition 12
"average" 12
WEEKNUM 12
Tip & Tricks 12
Rankx with filter 12
Dashboards 12
Sumx() 12
Matrix table 12
Text 12
"Calculation Group" 12
DAX Data Table 12
'Need help' 12
Formatting 11
Visuals 11
subtotal 11
join 11
Slicer based on calculated Measure 11
DAX Date condition 11
Advance DAX 11
function 11
date slicer 11
Variable calculation 11
SUMIF 11
Measures to filter out 11
RANKX issue 11
Filter Table 11
DAX&Power Query 11
pareto 11
Commands and Tips 11
needs help 11
Calculation Group 11
VLOOKUP 11
sorting 11
percentages 11
blanks 11
Row Level Security 11
Hints & Tips 10
@PowerBI Report 10
formulas 10
DAX SUMX 10
"Show and tell" 10
parameter 10
Please help 10
@power bi desktop 10
averages 10
Rolling 12 Months 10
Dynamic Ranking 10
How To 10
budget 10
sales 10
currency conversion 10
Currency 10
Search 10
Data Modelling 10
Moving average 10
General 10
Year 10
time functions 10
CONTAINSSTRING 10
Median 10
COUNTIF 10
grouping 10
datesinperiod 10
Last date 10
DAX Syntax 10
DAX Optimization 10
Switch Metric 9
Previous month 9
DAX Hierarchy 9
Performance Issues 9
Loop 9
keepfilters 9
context transition 9
Nead Help 9
Power BI Help 9
CALENDER 9
ADDCOLUMNS 9
@PowerQuery 9
CountIfs 9
Weekday 9
category 9
SUM based on some filter 9
@DateTime Functions 9
Data model 9
bar chart 9
M 9
isfiltered 9
measure based on slicer 9
IF Functions 9
PowerBI Help 9
query 9
Parent child 9
row context 9
PowerBI DAX 9
DAX SUM 9
grand total 9
subtotals 9
new column 9
dynamic table 9
group 9
parameters 9
Dynamic Date Period 9
date calculation 9
SSAS Tabular 9
Tableau 9
Countdistinct 9
Report 9
Standard Deviation 8
"DAX create dynamic table from slicer date" 8
"Power Pivot" 8
"Date" 8
'DAX' 8
firstdate 8
INACTIVE RELATIONSHIP 8
"Power Query" 8
FILTERS DAX KEEPFILTERS 8
Groupings 8
SSAS 8
Dynamic RLS 8
SQL to DAX 8
Merge 8
MoM 8
rolling 8
Time interval 8
OR 8
what if parameters 8
Clustered Column Chart 8
crossjoin 8
Calculate function with multiple criteria 8
" Error Handling" 8
Year over Year 8
distinct count 8
Conditional Formula 8
Reports 8
.DAX 8
previous year 8
COUNTA 8
COLUMN VALUES 8
legend 8
target 8
Average Grand Total 8
ORDER 8
Year to date 8
TREATAS 8
tabular 8
QTD 8
Need Help - Goals 8
Filter Multiple Column 8
LastDate 8
Row 8
@get help 8
beginner 7
churn 7
Filter Multiple Columns 7
"SELECTEDVALUE" 7
@ Matrix Visualisation Error In Calculation 7
isinscope 7
rolling sum 7
"DAX Query View" 7
Regression 7
Last Year 7
"Tips and Tricks" 7
Tabular Model 7
IF AND with multiple conditions 7
powerpivot 7
drill through 7
aggregate 7
cummulative 7
Table Column 7
DAX Language 7
Need Help re Measure Formatting 7
DATATABLE 7
@sumx 7
Offset 7
"DAX SWITCH" 7
DirectQuery 7
M Query 7
Calculate dates 7
logic 7
segmentation 7
multiple column 7
union 7
Inventory 7
syntax 7
weekly 7
exclude 7
Categories 7
custom column 7
date filter 7
Multiple columns 7
Many to Many Relatioinship 7
multiple tables 7
Between dates 7
today 7
relatedtable 7
unpivot 7
Advanced filtering 7
Iterator 7
subtract filtered value 7
DAX ALLSELECTED 7
calculated tables 7
Maxdate 6
DAX TOPN 6
@visual level filter 6
SharePoint 6
Power 6
previous 6
Summary 6
Headcount 6
Percentage Difference 6
"COUNT" 6
percentile 6
i need help 6
Show & Tell 6
In 6
Filter based on context 6
sumifs 6
Month Calculation 6
Latest 6
column selection 6
Intersect 6
Divide Function 6
Calendar Table 6
"FORMULA" 6
data 6
PBI Desktop 6
IF ELSE 6
recursive 6
PBI 6
duplicate 6
Conversion 6
comparison 6
Total not matching 6
CALENDAR() 6
Division 6
matrix calculation 6
optimize 6
Visual Filtering 6
ADDCOLUMNS() 6
dates between 6
previousmonth 6
RLS problems 6
conditional column 6
dax problem 6
"MAX" 6
color 6
Need Info 6
Variances 6
variance 6
COUNTAX 6
rolling average 6
isblank 6
Waterfall Chart 6
ID 6
dates table 6
Data Type 6
Calculated Measures Only 6
Networkdays 6
string 6
DAX Total 6
DAX code 6
graph 6
selected value 6
dax tip 6
tooltip 6
DAX Max Date within date range 6
Filter using a measure 6
snapshot 6
pivot 6
change 6
Average from Matrix 6
Duplicate data 6
dynamic filter 6
"VAR" 6
Visualization 6
Total wrong 5
Need a help 5
dax variable 5
Measure Totals 5
Custom Measures 5
Desktop version 5
profit and loss 5
commands 5
pivot table 5
Statistics 5
Modeling 5
Gantt chart 5
max date problem 5
Add Column 5
Pie Chart 5
" cumulatives" 5
Subtract 5
DAX TABLE 5
Average Rates 5
Dax Power Pivot 5
daxhelp 5
Moving average for measures 5
Week 5
Custom Time Intelligence Function 5
need 5
@inventory @DAX 5
Dynamic calculation 5
XIRR 5
Table variables 5
Duplicate Values 5
conditions 5
Week time intelligence 5
Conditional Sum 5
Hierarchical slicer 5
Dynamic Flag 5
Working Hours 5
distribution 5
i 5
graphs 5
datesytd 5
"SWITCH" 5
rolling 12 5
Unique Value 5
new measure 5
calculate columns 5
yoy 5
running balance 5
context filter 5
replace 5
@ 5
Calculate Sum 5
"Data Model" 5
mdx 5
tricks and tips 5
CODE 5
Nee help 5
Need help. 5
Questions 5
Need Hepl 5
New Table creation 5
DAX Performace 5
Path 5
Dax performance 5
"Dynamic Slicer" 5
line graph 5
SVG 5
"help" "targets" "tables" "Related" 5
Help using powerbi 5
Dynamic row level security 5
MIN date 5
Chart Help 5
tutorial request 5
maximum 5
measures in calculated columns 5
status 5
cumulative value 5
charts 5
need helps 5
"Grand Total" 5
"TOPN" 5
date format 5
multiple rows 4
Cohort Analysis 4
need Help with measure 4
P&L 4
@Show and Tell 4
Hierarchy of matrix 4
ALL Function 4
@PowerBI Report. @dax 4
dimensions 4
metric 4
bar charts 4
opening balance 4
HASONEFILTER 4
working days 4
IF THEN ELSE 4
stacked bar chart 4
count rows 4
Custom Visual 4
Quarter 4
Product 4
status change 4
relations 4
Direct Query mode 4
holidays 4
If Then 4
First Value 4
SCD2 4
DATESMTD() 4
Average by other column 4
@slicer 4
Dimension 4
expression 4
AVG 4
Query Editor 4
HR 4
growth rate 4
BINS 4
Date Calculation Error 4
New Table 4
metrics 4
weekly-averages 4
employee 4
Null 4
Workday 4
fiscal 4
Rolling AVG 4
dynamic title 4
IF = BLANK() 4
DAX ROW CONTEXT 4
TopN Customer 4
SLA 4
Power Query Editor 4
Dynamic Index 4
WTD 4
Quarter over Quarter 4
NOT 4
Total Measure 4
Earlier Function 4
Composite Model 4
Total wrong in matrix 4
utilization 4
Custom Filter 4
SUM based on existing context created by a measure 4
New quick measure 4
Help to Create Dax: applying filter for both Data Type(Text and Date) 4
Tip 4
GENERATESERIES 4
If function 4
Model 4
Live Connection 4
range 4
Advanced Visualization 4
% 4
OR function 4
salary 4
stock 4
Conditional Formatting column 4
Conditional measures 4
"if statement" 4
"powerbi" 4
Visualisations 4
multiple 4
selected values 4
hasonevalue 4
result 4
Calculatetable filter 4
DAX Relationships 4
monthlyaverage 4
Dax_Help 4
YoY calculation 4
"Calculated Columns" 4
finance 4
tutorials 4
date range 4
Rolling Months 4
conditional columns 4
dax calculations 4
"subtotal 4
PREVIOUSDAY 4
Customer 4
Dynamic Column 4
Security roles 4
WOW 4
Histogram 4
summarize table 4
Tabular Editor 4
calculated 4
Dynamic filters 4
Rolling Averages 4
Growth 4
Gauge 4
What If 4
rolling dates 4
Runnig Total 4
@average 4
"Time" 4
update 4
previous week 4
Fiscal Year 4
Measure Multiplication 4
Cumulative Totals by category 4
many to many 4
Sum & Totals 4
delta 4
DAX Divide Formula 4
DAX Filtering Slicer 4
Need help for Dax 4
dataset 4
Average Sales 4
multiple filters 4
Split column 4
Weekday calculation 4
Functions 4
advanced dax 4
Dashboard 4
DATESYTD Help needed 4
cumulative sum by category 4
weighted 4
cumulative total - running total 4
bridge table 4
Conditional Totals 4
Issue 4
tickets 4
BI Vs Tableau 3
Lookupvalues 3
empty columns 3
Userrelationship 3
Last 3
Flag 3
help measure 3
Trend Line 3
Need Suggestions 3
previous period 3
Time Based Filter 3
datamodel 3
Previous Row 3
SUMMARIZE. SUMX 3
normalize 3
Dynamic data selection based on date 3
facts filtering dimensions 3
DAX table filter 3
Previous row value 3
ratio 3
List 3
time calculation 3
Conditionals 3
@Cummilative 3
dynamic data filtering 3
benchmark 3
complex 3
Text Measure 3
Analysis in Excel 3
Control charts 3
Customers 3
hour 3
balance 3
DAX Switch() 3
mapping 3
% CHANGE 3
dax need help 3
DAX FILTER ISSUES 3
accumulated measure 3
DAX SUMMARIZE FILTER GROUPBY 3
" Time Intelligence" 3
Flow 3
Retention 3
XLOOKUP 3
Except 3
range of text 3
Substring 3
Accounting 3
new user 3
related table 3
Time Range 3
Average Averages 3
DAX Equation 3
Convert 3
Average of a result 3
Calculate function 3
negative 3
Counter 3
DAX for max utilisation 3
financial report 3
Find multiple values 3
DAX Division with Date 3
Intersection 3
Nested IF 3
KPI Ranking 3
period 3
%grand total 3
TimeIntelligence 3
HLP DAX formula 3
Average last 3 month 3
drillthrough 3
General Comments 3
slow 3
SUM of MAX 3
Day of Week 3
firstnonblank 3
attrition 3
DAX. 3
Fiscal Calendar 3
minimum 3
support 3
Count rows (date) by month 3
Dax Join 3
Visualizations 3
"aggregations" 3
Date DIFF 3
Lookup value 3
DAX Measur 3
Slow Performance 3
Virtual Tables 3
" cumulative " 3
How-to 3
BUG 3
survey data 3
New customers 3
Analysis 3
line chart visual 3
M language 3
circular 3
incorrect total 3
basket analysis 3
new calculated column 3
Days 3
Burndown 3
CURRENTGROUP 3
field parameter 3
Earliest Date 3
@ links to members 3
"Slicer" 3
Combining two Rank measures by category 3
Power Query Tips & Tricks 3
Cost 3
to 3
Filter two tables 3
Backlog 3
monthly growth 3
Date Function 3
@FORMAT 3
visual level filter 3
"Totals" 3
API 3
Calc column assistance 3
two tables 3
date interval 3
Column Chart 3
DAX CALENDARAUTO() 3
RankX excluding Some Values 3
Quarter Issue 3
aging 3
date averages 3
x-axis 3
Summary Tables 3
Help! 3
'Cumulative totals' 3
e 3
Max date from select dates in Dataset 3
fortnight 3
display 3
Calander 3
Start and end period 3
range of values 3
Select 3
Inventory Planning 3
lost customer 3
"category" 3
analysis services 3
dax mode count 3
calculated rows 3
weighted averages 3
General Question 3
Integer 3
Monthly percentages 3
visual filter 3
time-intelligence 3
optimization 3
Control Chart 3
Role level security - multiple levels 3
EOMONTH 3
Date filtering 3
dynamic filtering 3
@tables 3
Help me to find this DAX 3
Column Comparison 3
DAX Grouping and Counting 3
custom 3
FIFO 3
Help with DATESYTD DAX 3
Apply Filter 3
Weekly YOY 3
day 3
Parent 3
sum vs target 3
Combine tables 3
datefilter 3
Percent 3
DAX filters 3
recursion 3
complex dax 3
@divide 3
"Power BI Report Server" 3
R script 3
guidelines 3
relative date filtering 3
column total 3
SUM of Units 3
unique 3
Power Automate 3
Pareto Chart and table by Period help 3
Drill-through 3
sort formula 3
PARTITION 3
find 3
from 3
Measure Total with VAR and IF statements 3
DAX Filter table from slicer 3
"How To" 3
"Power Automate" 3
DAX Dynamic Top N 3
Running Balances 3
tooltips 3
transpose 3
Azure Analysis services tabular model 3
Absolute Value 3
active customers 3
PBIX Reports 3
grand total row incorrect 3
EarlierFunction 3
weeks 3
LOD 3
virtual 3
ROUND function 3
dynamic values 3
@Please Help HELP 3
Design 3
Data Visualization 3
Financial 3
text filter 3
Calendars 3
start 3
Field Value 3
cumulative percentage 3
count distinct with condition 3
Ignore Slicers 3
help with date 3
column formatting 3
Difference Between Dates 3
0 3
DAX Date Table 3
Need help! 3
Python 3
Sparkline 2
slow rendering 2
testing 2
Line and clustered column chart 2
Row Number in DAX 2
POP&L 2
running 2
Bin 2
Multiple Currency 2
isnonblank 2
@related @tables @relations 2
page filters 2
C 2
PowerBI Dax MAx 2
@previous month 2
firstnonblankvalue 2
comparing two different years. 2
big data 2
"Multiplication" 2
Auto-exist 2
ProductX 2
"CHART" 2
Business 2
queries 2
Analysis Service 2
radar chart 2
else 2
sankey 2
while 2
Append measure to table 2
Search table columns for similair data 2
Technical question 2
Group By For Two Columns in Dax 2
Window Function 2
customer concentration 2
Combine Values 2
Counting 2
Date Time 2
repurchase 2
segment 2
Future Dates 2
Help with Slicer. 2
Recent data 2
hierachy 2
ROUND 2
constant 2
CROSSJOIN UNION FILTER 2
CALCULATE TIME 2
Manage role 2
Help with DAX please 2
Latest Status by DAX 2
Percentage of total 2
Performance Issue 2
compare row value. 2
Other 2
Subscription 2
timeline 2
SAP 2
date ranges 2
multiple date tables 2
credit 2
Cross-Filtering 2
Line and stacked column chart 2
available 2
Financial Year 2
su 2
conditonal formatting 2
rowlevelsecurity 2
actuals 2
Meausre 2
True 2
DAX to Power M Query 2
Transform data 2
COMBINEVALUE 2
zero 2
heed help 2
DAX for Time Tracking 2
exact 2
wrong 2
dataverse 2
Recent date and time. 2
DAX groups or grouping values or text. Calculated columns 2
Measures to Columns 2
Date formatting to number 2
dynamic date 2
Bottom N 2
Not a number 2
ranking on filtered page 2
Variable column 2
Tips & Trick 2
"Tutorials" 2
Excel formula to Dax 2
Bookmarks 2
Gantt 2
Memory 2
Region 2
combine 2
mappings 2
Assigning Roles 2
Dynamics CRM 2
Total Sum 2
Custom Date Range on Date Slicer 2
expressions 2
SUMPRODUCT 2
LostBusiness 2
Delimiters 2
@stock_managment 2
binning 2
DATEADD Visit Windows 2
concatenate within SWITCH() 2
Create Combo Chart 2
Count of Counts 2
Rates 2
Max value in date range 2
Coloring 2
Measure DAX donut-chart axis countrows 2
sum row by row 2
LTM 2
DAX text 2
SELECTEDMEASURE 2
"Consecutive" 2
@amitchandak 2
DRE 2
"Expression" 2
"SEQUENCE" 2
Dax Studio connection error 2
dax code for calculated measures 2
GUID 2
label 2
Format Date 2
power bi visuals 2
Managing Roles 2
delete rows 2
Replace Values Based on Another Column 2
fill empy cell 2
yield 2
reference 2
@Ranks with Trend 2
Variation 2
Table cell background color 2
relative date slicer 2
newbie 2
dax calculated 2
multiplication 2
slicer selected column 2
@Slicer Date 2
IF(ISBLANK 2
consecutive 2
amount 2
DATEADD and min function DAX 2
Get previous value 2
Assistance 2
Models 2
SWITH 2
Date context 2
large dataset 2
"SELECTCOLUMNS" 2
Asking help 2
Neep Help 2
"Prior Month" 2
Linear Regression 2
DAX for dynamic difference calculations. 2
measure filters 2
DAX Tips &Tricks 2
"multiple criteria" 2
Security 2
R 2
Reporting 2
automation 2
refresh data 2
Turnover 2
Case statement 2
STARTOFMONTH 2
percentage of total column 2
Power BI & Power Apps 2
scalar value 2
Price difference of identical products 2
CONCATENATEX() 2
RollingForecast 2
Rolling attrition 2
Waterfall 2
% of sales 2
Different Fiscal month 2
subcategory 2
multiple conditions 2
Legends 2
"Format" 2
drill down 2
Groups 2
Strings 2
UserName 2
Shape Map 2
Icons 2
Events in progress 2
percentiles 2
Summerizecolumn 2
fiscal period 2
Approximate Lookup Dates 2
totals calculation not correct in matrix 2
new calculated table 2
SEQUENCE 2
cardinality 2
transform 2
direct query connection 2
unichar 2
QUOTIENT 2
longitude 2
Projections 2
Split Cost 2
DAX Measure TREATAS Child Parent Hierarchy 2
percentage of column total 2
Virtual Relationships 2
time series 2
Inventory Allocation 2
Filters based on context 2
DAX GROUPBY FILTER PERCENTILE.EXC 2
DAX Window Function 2
DAXMeasure 2
Last Month 2
DAX compare similar past period 2
@Parameter 2
Request 2
loading 2
link 2
selection 2
Sum on a dynamic date range 2
Data Analysis 2
new measure of % by group 2
YoY Line Charts 2
Report view 2
Rowtotal 2
iteration 2
evaluation context 2
Drilldown help 2
Point in time 2
Timestamp 2
Explicit measure 2
latitude 2
v 2
QUICKMEASURE 2
Tips &Tricks 2
@100% stacked bar chart 2
IRR 2
dinamic 2
hint 2
DAXformula 2
Conditional use of measures 2
bucketing 2
@Power BI Report Builder 2
Many to Many Relationship 2
@WeekName 2
date calculations 2
"Maxdate" 2
dax measure error 2
CUSTOMCOLUMN 2
Formula with Multiple Conditions 2
"Contoso" 2
Content 2
Quick Tips 2
database 2
outliers-detection 2
dropdown 2
Age 2
dependency 2
KPI Indicator 2
Past & Current Month Latest data 2
returns 2
font colour 2
conditional format 2
Conditional Formation Icons 2
ratio calculations dax 2
Running Total Weekly 2
Pareto Chart 2
Months between 2
DynamicMeasure 2
medianx 2
coordinates 2
hourly calendar 2
frequency 2
bar graph 2
PowerBI Countifs 2
higher education 2
TopN with Other 2
YTD on FiscalPeriod Filter 2
help and show 2
SUM of MIN 2
stop 2
table filtering 2
many-to-many 2
help dax 2
PowerBI Forecasting 2
@Calendar 2
Dax formaula 2
Custom Visuals 2
axis 2
Missing data 2
Latest Date 2
sumtotal 2
grouped 2
Custom calendar 2
30 2
coalesce 2
Selections 2
date hierarchy 2
Productivity 2
Decomposition Tree 2
contract 2
sum of measure 2
match value 2
power-BI 2
Prior year filtering 2
empty cells 2
cumul 2
% share 2
subset 2
progress 2
DAX count 2
Max per Category 2
Want to create a calculated column 2
interactive visuals 2
Inventory Management 2
Hours 2
Maximum value 2
"Dashboard Design" 2
% Growth 2
ignore 2
"Lines Chart" 2
Map 2
Paginated Report 2
BI 2
Streaming Datasets 2
Filter Changes 2
weekdays 2
custom formula 2
Substract with a measure 2
stacked column chart 2
Month on Month Rank Comparison 2
Add "IF" before calculate 2
capacity 2
TOTALMTD 2
Custom Formatting 2
help with matrix 2
current month 2
Multiplier 2
Penetration 2
Filtered table 2
Mesasure 2
Active Customer by Month 2
% difference 2
ranking multiple criteria DAX 2
Many-to-relationships 2
USERPRINCIPALNAME 2
Many to One Relationship 2
"DAX create dynamic table from slicer " 2
"Running Total" 2
portfolio 2
targets 2
New Help 2
searching from 2 tables 2
addcolumn 2
return 2
categorization 2
ageing AP & AR 2
runningtotal 2
select date 2
Gross Profit % 2
modelling 2
DAX Cumulative Filter 2
"Time Zone" 2
need help in DAX 2
Filtered Measures 2
expanded table 2
New Column Formula 2
gateway 2
date slicers 2
Power BI Data 2
gauges 2
filter pane 2
Visual Studio 2
many to many relationship issue 2
Multiplying by Sum 2
TOTALYTD through Today 2
Cumulative sum partition 2
Date Comparison 2
calculate Percentile 2
EARLIEST 2
Privacy 2
Button 2
slicer calculation 2
month-to-date 2
dynamic segmentation 2
PARALLELPERIOD 2
ROWNUM 2
Guidance 2
Date Issues DateTime 2
Excel formula 2
FILL DOWN IN DAX 2
Historical Data 2
equals 2
Prior Year 2
@ Matrix Vizualisation Error In Calculation 2
left join 2
blank values 2
filtered values 2
filter propagation 2
Dax power query 2
Column Formula Assistance 2
Mysql 2
User 2
t 2
data model issue 2
Hierarchy slicer 2
FX 2
Margin 2
Stock Valuation 2
dynamic column names 2
weighted distinct count 2
Child 2
revenue 2
cummulative dax 2
Navigation 2
DatesMTD 2
Previous Quarter 2
Tenure 2
running average 2
Orders 2
@PowerBI Report Server 2
power bi filter 2
X axis 2
Rollup 2
percent change 2
dynamic lookupvalue 2
Trial Balance 2
Location 2
DAX tables 2
"Time Conversion" 2
fact table 2
Max Values 2
Paginated Reports 2
Benchmarking 2
Grouped field 2
Expertise help 2
Extract 2
Summarize() 2
Group total 2
Likert scale 2
Data Transformation 2
Empty 2
cohort 2
count of consecutive days 2
Fact 2
Missing Dates 2
SUMPRODUCT Measure 2
Date Parameter 2
Calculate difference consecutive rows 2
Multiple Values 2
Fiscal Week 2
SELECTEDVALUE() 2
d 2
sum total 2
Multiple Criteria 2
measure column 2
aggregated 2
above 2
Fixed Year 2
DistinctCountX 2
shifts 2
ALL page filters 2
RELATED() 2
Remove Filters 2
"parameter" 2
subtraction of Row 2
"M Query" 2
New Challenge 2
error message 2
Match 2
not equal to 2
drill 2
query folding 2
COVID-19 2
Market Share 2
custom sorting 2
Operator 2
Top5 with Other column 2
bell curve 2
countblank 2
Concatenate columns in a measure 2
partial 2
"LOOKUP" "DATA" "PERIOD" "INTERVAL" "BETWEEN" "SELECT" "FILTER" "TABLE" 2
CONFIDENCE 2
DAX to return slicer status 2
indexing 2
Level of detail 2
Single Column 2
minutes 2
NECESITO AYUDA 2
unrelated 2
Lists 2
card visualization help 2
Accumulate 2
exchangerate 2
same values 2
daX ERROR 2
measure dynamic formatting 2
@FTE 2
DAX for Table filter from column in another table 2
@ excel table 2
"Hierarchies" 2
DAX AVERAGE 2
Measure Help 2
Salesforce 2
live dashboards 2
1 2
Edit In Power BI Desktop 2
Dataflows 1
iamprajot 1
Power Apps 1
Unhandled 1
changing classifications 1
Stock In Hand 1
Replace Text Based on Another Column 1
ONE TABLE MODEL 1
Issues 1
TopN by Store 1
Atingir Meta e Solver 1
filter direction 1
Refreshing 1
To Show Ratio 1:2 1
BusinessCentral COA Totalling 1
90 1
deadline 1
tMonth 1
overlaying graph 1
true () 1
rangos 1
Dynamic slicer flag column 1
Power M Query 1
Deaths 1
Past Due 1
Expanded Tables 1
av 1
Open 1
I will pay you 1
Last purchase price 1
DAX Ca 1
filtre 1
True False Expression 1
Generate 1
two dimdate tables 1
Top product name 1
DTD 1
Monthlt ratios 1
date filters 1
Rolling Average Quarterly 1
Dax Calendar Table 1
filt 1
Joining 1
Weibull 1
lady 1
reduce size of model 1
bz 1
need help PATH function 1
measures Line total 1
completed tasks 1
occurunce 1
Night shift 1
cycle time 1
Shortage 1
Nan Error 1
If staments 1
efficiency mode 1
aggregating 1
concatenation 1
power bi destop 1
Filter by range interval 1
SSAS CUBES POWERBI OLAP 1
datagroups 1
Status Bar in Power BI 1
I want to show percentages under each month value 1
@cond 1
Seeking Help 1
BI Views 1
Shadow Filter Context 1
Return Recent with exception 1
filter table based on slicer 1
SELECTEDVALUES 1
Actua 1
system measures 1
calculate colun 1
CENSUS 1
"bitwise" 1
"Text" 1
payperiod 1
Date Conversion 1
parameteer 1
Single Select 1
POS 1
"INNER JOIN" 1
directqury 1
RIGHT 1
Dax summarizecolumns count items per group 1
año mobil 1
90th 1
detection 1
"Relationship with value less or equal than" 1
Need help on the Dax 1
Self-referencing 1
DAX for IF 1
Matrix Totals help 1
multiple selection 1
active per month 1
Dynamic Slicers 1
LINESTX 1
dropdown menu 1
DAX function HELP 1
self join 1
schedule 1
Power Bi Reports 1
external users 1
Dynamics 365 1
123 1
Data Security 1
scatterplot 1
ovetteabejuela 1
subgroups 1
12 month 1
one row 1
PaginatedReports. ReportServer 1
Time Zone 1
aaa 1
Analysis Server 1
ALLSELECT SURVIVAL RATE 1
Nominator 1
remote computers 1
work load 1
chart axis with no data 1
Tag rows 1
org chart 1
simulation 1
Report Data 1
KEEP 1
record 1
Reverse Cumulative 1
Invoices 1
availability 1
Rolling 6 months data 1
Close and Backlog Tickets 1
Historic Table 1
Stocks 1
Compare quarter wise data 1
date axis 1
PBI SQL SERVER 1
cds 1
Null to Zero 1
selected 1
files 1
Monthly 1
comma 1
logical or 1
returning customers 1
Credits 1
peak 1
Alphabatic 1
mostrar ultima cifra de la columna 1
SubstituteWithIndex 1
needs 1
Mastering DAX 1
manual value 1
RANKX by quarter 1
heavy database 1
sprint 1
r wa 1
NaN 1
measure based 1
LEFT 1
data view 1
occurrence 1
Relative Dates 1
Projected raw data 1
macros 1
formating matrix 1
MAXA 1
@Greg_Deckler 1
PowerBI_cellule contient ce mot 1
CHANGE ROW VALUE 1
History trend 1
Equations 1
Dynamic data selection 1
Max value 1
data label 1
SUMIFS_PowerBI_DAX 1
PowerAutomate 1
burndown chart 1
OData EveryAngle Refresh 1
changing data 1
"downtime" 1
"Contains" 1
Laptime Format 1
"PATHCONTAINS" 1
Count() 1
Selectcolumns table filtering 1
Point of Sales 1
"Mahmoud Linux" 1
12 Weeks 1
Ranks 1
Ranking Multiple Measures 1
custom date table "FinancialMonth" 1
COSSSJOIN 1
Attribution effect 1
Filters interference 1
Exclude Filters on visuals 1
Dynamnic 1
active users trend 1
Qliksense 1
AVERAGE PER DAY 1
Max (date) in Calculate 1
Interconnected Slicers 1
Scalar Types 1
white 1
customer count 1
Card and RLS 1
Cards 1
survey 1
Embed 1
delete 1
Test 1
Active Directory 1
Schedule Refresh 1
Sync Slicer 1
slicer value used in a different way 1
v-qiuyu-msft 1
helps 1
Custom Time Period for Dataset 1
Icon Formatting 1
transformation 1
child objects 1
correct visuals 1
total zero 1
bad data 1
in chosen periods 1
title 1
azure devops 1
Denominator 1
Dinamic rows 1
Top5 and Bottom 5 1
NewBusiness 1
volume concentration 1
DAX formula for tracking daily death cases 1
Password 1
Alias on summ 1
Conteo 1
webpagelinking 1
Error Handling 1
non-zero 1
- B 1
Historic Data 1
MEDIDAS CON FECHAS 1
hires 1
show all values 1
"Time update" "Report" 1
Empty rows 1
Direct Active Relationship 1
National Insurance 1
injury 1
userelationship rowlevelsecurity 1
secondary y-axis 1
self query 1
next 1
Debits 1
Copying Data 1
next 7 days 1
MDX forums 1
iserror 1
Stage 1
BW 1
Exclude from measure 1
Filter by two combinded columns 1
sprint planning 1
symbol 1
morning shift 1
filters on visuals 1
NOW() 1
LEN 1
frequência 1
FirstNonEmpty 1
@ignoring slicers 1
last change 1
level 1
majority of average 1
Cumulative total for same Period Last year 1
Exclude certain values from MTD 1
calculated col 1
@hekp 1
@RLS 1
@Mich_J 1
most recent 1
Radar chart. DAX 1
hours overdue 1
distinct values 1
matriz 1
Recurring 1
"data refresh" 1
aneurysm 1
calcualted column 1
timeseries 1
"syntax" 1
Countries 1
n 1
Scatter plot 1
Populate 1
rolling timeframe 1
"NATURALINNERJOIN"" 1
Sliders 1
No Dates 1
ignore filter 1
IFAND 1
secondary axis 1
end 1
System Average 1
Query View 1
lingaro 1
Multiple measure 1
engagement trend 1
"Grouping" 1
horometer 1
returning a value based on other columns values 1
calculated DAX 1
align 1
string split 1
labels 1
General Info 1
Data Science 1
How 1
Azure 1
data refresh 1
Feature Comparison 1
oracle 1
Json 1
Focus slicer 1
D3 1
row_number 1
Usage Metric 1
stage change 1
Production 1
debit 1
include 1
Need to mark holidays in calendar 1
DAX com 1
Customer Items 1
have 1
show statusRDP 1
able 1
concentration curve 1
perce 1
Error of Expression Refers to multiple columns. Multiple columns cannot be converted to scalar value 1
optimised 1
filtrar 1
Multidimensional 1
math 1
unico 1
ifelse 1
help wanted 1
Previous YTD for Ranked Sales 1
Summing Measures 1
Intersect() 1
hierarchy slicer merge text 1
Outstanding 1
Store Data 1
Metric Switch 1
Output 1
same table 1
project for the web 1
intervalmatch power bi 1
maria db 1
Weighted Average Price 1
nullby0 1
Text Box 1
gap 1
drill up 1
longitudinal 1
duplicaterows 1
Powerbi Report Builder 1
interpolation 1
override filter 1
Difference in one Column 1
Cumulative Emissions 1
Power BI Desktop for Report Server 1
col 1
Speedtime 1
@paginated report 1
poor 1
ISEMPTY 1
Measure excluding 1
cross check 1
for 1
selectitem 1
afteron shift 1
how can we concatenate columns dynamically using DAX 1
MovingAverage 1
Create column 1
I tried using an if else statement and it used too many resources 1
Indexes 1
containsstrings 1
conditional count 1
column statistic 1
DAx sumifs formula referencing a cell 1
PYTD 1
latest record 1
radar 1
"Table" 1
Measure table 1
Exposure forecast 1
Blocks of Time 1
rollingsum 1
tion 1
changes 1
COTAINS 1
Hourly 1
ISSELECTEDMEASURE 1
table variable 1
datesadd 1
Dynamic Percentile lines 1
Boolean Expression 1
target line 1
slicer selection 1
Custom Tooltip 1
Need Help for Dax Measure 1
DIFF 1
"Filters" 1
rollover 1
Top N rows and SUm 1
aggregations 1
"WINDOW" 1
Show Only Latest Sequence 1
last change date 1
daxstudio 1
Percentage of actions completed 1
Increment 1
Sum in Sub-Total and Average in Grand Total 1
"Counting" 1
use rates 1
columns not return expected values 1
"Recurring Revenue" 1
Time intellegence 1
different 1
value comparision 1
Extreme weather 1
Best Practices 1
Roundup 1
Roles 1
Embed Report 1
scale 1
SQL Server Database 1
repeated 1
links 1
logs 1
. 1
incorrect 1
[help needed] 1
last date time refresh 1
dashboard dax help 1
opportunity stage 1
Match calculated ranking column 1
multi-value 1
Gateway issue 1
reference text 1
Clustered 1
remote desktop connection 1
Performance issues with AverageX 1
Previous Month Last Year Card 1
daily difference 1
ReturningBusiness 1
customer percentage vs sales percentage 1
Every 1
@Add comments 1
time format 1
Filtering using URL 1
exponent 1
Transliteration 1
first per day 1
Load Time 1
unix 1
change logs 1
apply 1
B 1
Python script 1
Advanced editor 1
extract date 1
unique values to date 1
business day 1
DMV 1
last value 1
LOOKUPVALUE() 1
Seriallabel 1
Nested Filter 1
DAX _ Moving Average 1
percentage of row total 1
sickne 1
measure in "column field" of matrix visual 1
attrition Rate 1
rolling values 1
merged 1
Differencies 1
perofrmance 1
Sub-Totals 1
bonus 1
exclude intersection 1
Value of last transaction 1
need help to pull latest msg 1
relativepath 1
months 1
Operating Profit 1
Last Week 1
header 1
Tableau to DAX code 1
colors 1
relativity 1
Show current week 1
Help in adding and dividing column total 1
Data error 1
first entry of the day 1
dynamic count 1
WeeklyTotal 1
Detail Row Expression 1
facttables 1

Be one of the first to start using Fabric Databases.

Join the discussion

Helpful resources