DAX Commands and Tips

Join the discussion

Pareto rule for multiple columns

by on Latest post on by

2 Replies 505 Views

2 Replies

505 Views

Running Total by Count of Action - Pareto Chart

by on Latest post on by

1 Reply 423 Views

1 Reply

423 Views

Helpful resources

DAX 3,920
Need Help 2,964
"DAX" 509
help 435
DAX Calculation 413
"Need Help" 327
Filter 324
Need Help DAX 324
Measures 293
"DAX help" 289
measure 278
Tips and Tricks 252
Help Requested 237
Power BI 232
CALCULATE 231
Show and Tell 217
Need Help DAX measure 190
DAX Commands and Tips 169
COUNT 154
Help appreciated 148
Help me please 147
Date 144
Dax Help 138
Slicer 134
Help me 132
@Dax 130
@Dax help 123
RANKX 113
DAX Measures 112
Tutorial Requests 110
SUMMARIZE 110
"DAX " 109
Help with DAX 105
DAX Commands 103
Help required 101
Help Request 95
powerbi 93
sum 88
average 86
Time Intelligence 86
"Help" 83
Table 78
@dax @help 77
Power Query 75
@Daxhelp 75
dates 74
DAX help needed 72
@NeedHelp 71
DAX Query 70
matrix 69
Calculated columns 68
POWER BI Dax rules 67
DATEDIFF 67
if 67
sumx 62
COUNTROWS 61
"MEASURE" 61
LOOKUPVALUE 60
Filters 58
"DAX Commands and Tips" 56
"DAX " "DAX help" 'Need help' 'DAX' 56
"Calculated Column" 54
Formula 54
Conditional Formatting 54
"Power BI" 53
TopN 52
calculated column 51
"CALCULATE" 51
Help with DAX Measure 49
Matrix Visual 47
Desktop 46
help needed 46
Max 46
General Comment 45
"FILTER" 45
SELECTEDVALUE 44
DAX filter formula 42
Need Assistance 42
"DAX " "DAX help" 'Need help' 41
dax measure 40
Power BI Dax 39
percentage 38
DAX Formulas 38
distinctcount 37
RLS 37
ALLSELECTED 37
all 37
Get Help 37
Filtering 37
MAXX 36
running total 36
Power BI Desktop 36
YTD 35
rank 35
if statement 34
ALLEXCEPT 34
switch 34
Distinct Counts 34
Filter context 34
@Dax Measure Error 33
divide 33
@Power BI 33
DATEADD 33
'Need help' 'DAX' 33
groupby 32
ranking 32
PowerBI Desktop 32
@Please Help 32
Group By 31
DAX Filtering 31
Hierarchy 31
Running Totals 30
@help 30
values 30
slicers 30
DAX ALL PowerBI Excel 30
"dax code" 29
Distinct 29
"beginner asks Help" 29
Switch() 29
DAX Power BI 29
DAX Command 28
USERELATIONSHIP 28
dax formula 28
column 28
Cumulative Sum 28
Data Modeling 28
Urgent Help with DAX 27
datesbetween 27
EARLIER 27
Aggregation 26
Excel 26
tables 26
Virtual Table 26
Dynamic 26
needhelp 26
" Slicer" 25
Visual 25
Measure Column Total 25
SUMMARIZECOLUMNS 25
DAX FILTER 25
All() 25
total 25
Compare 24
Tips & Tricks 24
"DAX help" DAX 24
Calculatetable 24
Totals 23
Power Pivot 23
REMOVEFILTERS 23
DAX RANKX 23
Interesting Links 23
Cumulative Total 22
DAX tips 22
calculation 22
calculated table 22
Data Protection 22
Calculated Measures 22
@measure 22
blank 22
VAR 22
relationships 21
variables 21
Date and Time 21
CONCATENATEX 21
@need help 21
error 20
Month 20
min 19
DAX. CALCULATE 19
calendar 19
Format 19
time 19
calculation groups 18
Urgent Help 18
@Conditional Formatting 18
MTD 18
Forecasting 18
lookup 18
"RANKX" 18
averagex 18
Need Dax 17
average of a measure 17
"Dates" 17
Dax commands help 17
chart 17
DAX Time Intelligence 17
index 17
card 17
Dax studio 17
Need Help -DAX Measures 17
related 17
if condition 17
cumulative 17
Formula Help 17
"Time Intelligence" 17
columns 17
Tips 17
SQL 17
Top N 16
Sameperiodlastyear 16
PowerBI Community 16
Circular dependency 16
Line chart 16
Cumulative Calculation 16
Date Table 16
Field parameters 16
MAX date 16
CONTAINS 16
dax functions 16
Need Urgent Help 15
@powerbi 15
duration 15
Need help (Using direct query) 15
DAX SUMMARIZE 15
COUNTX 15
Urgent 15
value 15
forecast 15
If statements 15
Need Help in Power Bi 15
"Date Table" 15
SAME PERIOD LAST YEAR 15
conditional 15
Table Visual 15
Need help with DAX 15
KPI 15
Calculations 15
Running totals and cumulatives 15
"DAX" "Earliest date" 15
CUMULATIVE COUNT 14
Direct Query 14
Slicer Visualizations 14
Related Tables 14
DAX Direct Query 14
DAX Averages 14
help in dax Function 14
DAX SWITCH 14
DAX For Filter 14
Advance DAX 14
crossfilter 14
"CALCULATETABLE" 14
POWER BI DATA VİEW 14
DAX function 14
Matrix Visualisation 14
context 14
Cumulative Totals 13
AND 13
Need DAX Help 13
variable 13
Tutorial 13
rows 13
@measure filter 13
condition 13
Date measures to filter data. 13
relationship 13
Performance 13
DAX BUG 13
PowerQuery 13
concatenate 13
Optimizing DAX 13
LASTNONBLANK 13
sort 13
Duplicates 13
Difference 13
question 13
"Calculation Group" 13
TOTALYTD 12
minx 12
weighted average 12
'Need help' 12
column calculation 12
"average" 12
WEEKNUM 12
@power bi desktop 12
Tip & Tricks 12
Rankx with filter 12
Dashboards 12
DAX&Power Query 12
Text 12
Sumx() 12
Matrix table 12
DAX Data Table 12
parameter 11
@PowerBI Report 11
Formatting 11
Visuals 11
join 11
Slicer based on calculated Measure 11
subtotal 11
DAX Date condition 11
"Show and tell" 11
date slicer 11
Variable calculation 11
function 11
pareto 11
SUMIF 11
Data Modelling 11
RANKX issue 11
Filter Table 11
Measures to filter out 11
Commands and Tips 11
VLOOKUP 11
Median 11
needs help 11
Row Level Security 11
blanks 11
sorting 11
percentages 11
Calculation Group 11
DAX Syntax 10
Hints & Tips 10
DAX Optimization 10
Please help 10
formulas 10
DAX SUMX 10
averages 10
category 10
ADDCOLUMNS 10
How To 10
Dynamic Ranking 10
Rolling 12 Months 10
sales 10
currency conversion 10
budget 10
General 10
Currency 10
Search 10
Moving average 10
group 10
Year 10
time functions 10
CONTAINSSTRING 10
DAX SUM 10
COUNTIF 10
grouping 10
datesinperiod 10
Last date 10
Countdistinct 9
Switch Metric 9
Previous month 9
Tableau 9
DAX Hierarchy 9
"DAX create dynamic table from slicer date" 9
Performance Issues 9
Loop 9
context transition 9
Nead Help 9
Power BI Help 9
keepfilters 9
CALENDER 9
"Date" 9
Data model 9
bar chart 9
Weekday 9
SUM based on some filter 9
CountIfs 9
@PowerQuery 9
query 9
M 9
isfiltered 9
measure based on slicer 9
@DateTime Functions 9
PowerBI Help 9
IF Functions 9
row context 9
Parent child 9
new column 9
PowerBI DAX 9
parameters 9
grand total 9
subtotals 9
Conditional Formula 9
Dynamic Date Period 9
dynamic table 9
date calculation 9
" Error Handling" 9
SSAS Tabular 9
Report 9
LastDate 8
Row 8
@get help 8
Standard Deviation 8
SSAS 8
firstdate 8
INACTIVE RELATIONSHIP 8
Groupings 8
"SELECTEDVALUE" 8
"Power Pivot" 8
FILTERS DAX KEEPFILTERS 8
Dynamic RLS 8
'DAX' 8
SQL to DAX 8
Merge 8
"Power Query" 8
DirectQuery 8
MoM 8
rolling 8
Time interval 8
"Tips and Tricks" 8
what if parameters 8
Clustered Column Chart 8
Calculate function with multiple criteria 8
crossjoin 8
OR 8
Reports 8
Year over Year 8
.DAX 8
previous year 8
COUNTA 8
COLUMN VALUES 8
"DAX SWITCH" 8
legend 8
target 8
distinct count 8
Average Grand Total 8
Many to Many Relatioinship 8
Year to date 8
tabular 8
ORDER 8
TREATAS 8
QTD 8
Need Help - Goals 8
Filter Multiple Column 8
"Dynamic Slicer" 7
beginner 7
Filter Multiple Columns 7
churn 7
@ Matrix Visualisation Error In Calculation 7
isinscope 7
Regression 7
Last Year 7
@visual level filter 7
powerpivot 7
drill through 7
Tabular Model 7
rolling sum 7
Table Column 7
aggregate 7
cummulative 7
DAX Language 7
Need Help re Measure Formatting 7
DATATABLE 7
IF AND with multiple conditions 7
"DAX Query View" 7
M Query 7
@sumx 7
Division 7
Calculate dates 7
Calendar Table 7
segmentation 7
multiple column 7
union 7
Inventory 7
syntax 7
Offset 7
weekly 7
logic 7
custom column 7
date filter 7
Multiple columns 7
exclude 7
Categories 7
Between dates 7
today 7
rolling average 7
multiple tables 7
Data Type 7
relatedtable 7
Advanced filtering 7
Iterator 7
dynamic filter 7
unpivot 7
DAX ALLSELECTED 7
"MAX" 7
calculated tables 7
subtract filtered value 7
SharePoint 6
Power 6
Maxdate 6
percentile 6
Headcount 6
Percentage Difference 6
"VAR" 6
previous 6
Summary 6
i need help 6
DAX TOPN 6
In 6
Filter based on context 6
sumifs 6
@inventory @DAX 6
Latest 6
Show & Tell 6
@PowerBI Report. @dax 6
data 6
PBI Desktop 6
Intersect 6
Month Calculation 6
"COUNT" 6
PBI 6
column selection 6
recursive 6
optimize 6
Visual Filtering 6
duplicate 6
Conversion 6
comparison 6
IF ELSE 6
CALENDAR() 6
matrix calculation 6
Conditional Sum 6
Divide Function 6
Total not matching 6
ADDCOLUMNS() 6
dates between 6
RLS problems 6
"FORMULA" 6
color 6
Need Info 6
previousmonth 6
conditional column 6
dax problem 6
COUNTAX 6
graph 6
Waterfall Chart 6
Variances 6
variance 6
Calculated Measures Only 6
Networkdays 6
string 6
snapshot 6
ID 6
dates table 6
DAX Max Date within date range 6
Filter using a measure 6
isblank 6
"Calculated Columns" 6
Duplicate data 6
pivot 6
change 6
selected value 6
dax tip 6
tooltip 6
Average from Matrix 6
DAX Total 6
DAX code 6
Visualization 6
Chart Help 5
Custom Measures 5
cumulative value 5
Total wrong 5
Need a help 5
dax variable 5
charts 5
Modeling 5
Gantt chart 5
max date problem 5
Desktop version 5
commands 5
pivot table 5
Statistics 5
need helps 5
Add Column 5
Pie Chart 5
profit and loss 5
Subtract 5
DAX TABLE 5
Average Rates 5
"Grand Total" 5
need 5
" cumulatives" 5
Moving average for measures 5
Week 5
Custom Time Intelligence Function 5
stacked bar chart 5
"TOPN" 5
Dynamic calculation 5
XIRR 5
Table variables 5
Dax Power Pivot 5
daxhelp 5
Measure Totals 5
conditions 5
distribution 5
i 5
Week time intelligence 5
Working Hours 5
Duplicate Values 5
graphs 5
Dynamic Flag 5
datesytd 5
Hierarchical slicer 5
yoy 5
new measure 5
calculate columns 5
mdx 5
selected values 5
running balance 5
rolling 12 5
Unique Value 5
replace 5
@ 5
Questions 5
context filter 5
Nee help 5
Need help. 5
tricks and tips 5
CODE 5
Path 5
Calculate Sum 5
"SWITCH" 5
Need Hepl 5
New Table creation 5
DAX Performace 5
"help" "targets" "tables" "Related" 5
"if statement" 5
Dynamic row level security 5
line graph 5
SVG 5
many to many 5
MIN date 5
Growth 5
Dax performance 5
"Data Model" 5
"powerbi" 5
tutorial request 5
measures in calculated columns 5
status 5
Help using powerbi 5
date format 5
maximum 5
weighted 4
cumulative total - running total 4
Sum & Totals 4
delta 4
DAX Divide Formula 4
DAX Filtering Slicer 4
Need help for Dax 4
"Time" 4
dimensions 4
DATESYTD Help needed 4
cumulative sum by category 4
Cohort Analysis 4
need Help with measure 4
P&L 4
Functions 4
@Please Help HELP 4
advanced dax 4
"Power Automate" 4
Custom Visual 4
metric 4
multiple rows 4
opening balance 4
HASONEFILTER 4
working days 4
IF THEN ELSE 4
bridge table 4
Conditional Totals 4
Quarter 4
Product 4
bar charts 4
First Value 4
SCD2 4
DATESMTD() 4
Average by other column 4
@Show and Tell 4
Hierarchy of matrix 4
Query Editor 4
status change 4
relations 4
Direct Query mode 4
holidays 4
If Then 4
expression 4
AVG 4
count rows 4
@Cummilative 4
Dimension 4
Except 4
growth rate 4
BINS 4
Date Calculation Error 4
New Table 4
@slicer 4
ALL Function 4
TopN Customer 4
SLA 4
metrics 4
weekly-averages 4
employee 4
financial report 4
HR 4
Workday 4
fiscal 4
Rolling AVG 4
dynamic title 4
IF = BLANK() 4
Average of a result 4
Null 4
Dynamic Index 4
WTD 4
Quarter over Quarter 4
NOT 4
Total Measure 4
%grand total 4
Model 4
Live Connection 4
Composite Model 4
Power Query Editor 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
DAX ROW CONTEXT 4
Visualisations 4
range 4
Advanced Visualization 4
Total wrong in matrix 4
utilization 4
stock 4
Conditional Formatting column 4
Earlier Function 4
finance 4
tutorials 4
multiple 4
% 4
OR function 4
salary 4
Calculatetable filter 4
monthlyaverage 4
GENERATESERIES 4
If function 4
Customer 4
Dynamic Column 4
hasonevalue 4
result 4
conditional columns 4
dax calculations 4
Conditional measures 4
"Slicer" 4
Many to Many Relationship 4
" cumulative " 4
What If 4
Security roles 4
WOW 4
date range 4
Rolling Months 4
Histogram 4
summarize table 4
Tabular Editor 4
calculated 4
Dynamic filters 4
Dax_Help 4
YoY calculation 4
update 4
previous week 4
Fiscal Year 4
Runnig Total 4
"subtotal 4
PREVIOUSDAY 4
dataset 4
Measure Multiplication 4
rolling dates 4
Rolling Averages 4
Gauge 4
Dashboard 4
Cumulative Totals by category 4
Average Sales 4
multiple filters 4
Split column 4
Weekday calculation 4
@average 4
complex dax 4
Issue 4
tickets 4
help with date 3
column formatting 3
Difference Between Dates 3
0 3
DAX Date Table 3
Measure Total with VAR and IF statements 3
DAX Filter table from slicer 3
"How To" 3
DAX Grouping and Counting 3
"DAX create dynamic table from slicer " 3
"Running Total" 3
Sparkline 3
count distinct with condition 3
Ignore Slicers 3
Userrelationship 3
Last 3
Flag 3
help measure 3
Trend Line 3
Need Suggestions 3
previous period 3
Time Based Filter 3
ROUND function 3
dynamic values 3
normalize 3
BI Vs Tableau 3
Lookupvalues 3
empty columns 3
DAX table filter 3
Previous row value 3
ratio 3
Need help! 3
DAX Dynamic Top N 3
Running Balances 3
Flow 3
benchmark 3
complex 3
Dynamic data selection based on date 3
facts filtering dimensions 3
Analysis in Excel 3
Control charts 3
Customers 3
hour 3
balance 3
datamodel 3
Previous Row 3
SUMMARIZE. SUMX 3
date ranges 3
Text Measure 3
range of text 3
Substring 3
Accounting 3
new user 3
related table 3
Time Range 3
Average Averages 3
List 3
time calculation 3
Conditionals 3
drillthrough 3
General Comments 3
slow 3
negative 3
Counter 3
DAX for max utilisation 3
Retention 3
XLOOKUP 3
Custom Date Range on Date Slicer 3
DAX Division with Date 3
Intersection 3
Nested IF 3
KPI Ranking 3
DAX Switch() 3
mapping 3
"MATRIX" 3
support 3
Count rows (date) by month 3
Find multiple values 3
Day of Week 3
firstnonblank 3
attrition 3
DAX. 3
DAX Equation 3
Convert 3
% CHANGE 3
dax need help 3
Tips & Trick 3
dynamic data filtering 3
BUG 3
survey data 3
Dax Join 3
Visualizations 3
SUM of MAX 3
Date DIFF 3
Lookup value 3
DAX Measur 3
period 3
TimeIntelligence 3
HLP DAX formula 3
Average last 3 month 3
Calculate function 3
DAX FILTER ISSUES 3
accumulated measure 3
DAX SUMMARIZE FILTER GROUPBY 3
Power Query Tips & Tricks 3
Cost 3
to 3
New customers 3
Analysis 3
"aggregations" 3
basket analysis 3
new calculated column 3
Days 3
Fiscal Calendar 3
" Time Intelligence" 3
API 3
line chart visual 3
M language 3
circular 3
incorrect total 3
Backlog 3
monthly growth 3
frequency 3
Slow Performance 3
Virtual Tables 3
minimum 3
DAX Tips &Tricks 3
Paginated Report 3
Calc column assistance 3
two tables 3
Filter two tables 3
DAX CALENDARAUTO() 3
RankX excluding Some Values 3
Quarter Issue 3
DAX Relationships 3
aging 3
date averages 3
Burndown 3
CURRENTGROUP 3
field parameter 3
Earliest Date 3
@ links to members 3
analysis services 3
e 3
Max date from select dates in Dataset 3
date interval 3
Column Chart 3
display 3
Calander 3
Start and end period 3
range of values 3
Date Function 3
@FORMAT 3
visual level filter 3
How-to 3
dax mode count 3
calculated rows 3
fortnight 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
x-axis 3
Summary Tables 3
subset 3
Help! 3
date calculations 3
Combining two Rank measures by category 3
R script 3
guidelines 3
relative date filtering 3
column total 3
custom 3
weighted averages 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
Select 3
tooltips 3
transpose 3
SUM of Units 3
unique 3
FIFO 3
Help with DATESYTD DAX 3
Pareto Chart and table by Period help 3
Drill-through 3
sort formula 3
PARTITION 3
find 3
EOMONTH 3
Date filtering 3
dynamic filtering 3
@tables 3
Help me to find this DAX 3
Column Comparison 3
Inventory Planning 3
'Cumulative totals' 3
"Totals" 3
Design 3
Data Visualization 3
Financial 3
text filter 3
Azure Analysis services tabular model 3
Power Automate 3
grand total row incorrect 3
EarlierFunction 3
weeks 3
LOD 3
virtual 3
from 3
Historical Data 3
Parameters switch 3
recursion 3
@divide 3
"Power BI Report Server" 3
Many-to-relationships 3
lost customer 3
"category" 3
Python 3
Calendars 3
start 3
Field Value 3
cumulative percentage 3
Absolute Value 3
active customers 3
PBIX Reports 3
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
percent change 2
dynamic lookupvalue 2
Trial Balance 2
Location 2
below 2
@ Matrix Vizualisation Error In Calculation 2
left join 2
need help in DAX 2
Filtered Measures 2
expanded table 2
New Column Formula 2
PowerBi Matrix 2
Business 2
queries 2
Analysis Service 2
radar chart 2
else 2
slow rendering 2
not equal to 2
drill 2
query folding 2
COVID-19 2
Market Share 2
custom sorting 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
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
linechart 2
DAX tables 2
"Time Conversion" 2
blank values 2
filtered values 2
filter propagation 2
Dax power query 2
Column Formula Assistance 2
survey 2
Other 2
Subscription 2
timeline 2
sankey 2
while 2
testing 2
Line and clustered column chart 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
Invoices 2
Help with Slicer. 2
Recent data 2
hierachy 2
C 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
fact table 2
Max Values 2
Bookmarks 2
Gantt 2
Memory 2
SAP 2
Append measure to table 2
Search table columns for similair data 2
Technical question 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
PowerBI Dax MAx 2
Dax Calendar Table 2
@previous month 2
firstnonblankvalue 2
comparing two different years. 2
big data 2
"Multiplication" 2
Auto-exist 2
DAX for Table filter from column in another table 2
RELATED() 2
Remove Filters 2
"parameter" 2
subtraction of Row 2
"M Query" 2
"PYTD" 2
label 2
Format Date 2
Region 2
combine 2
mappings 2
Assigning Roles 2
multiple date tables 2
credit 2
Cross-Filtering 2
Line and stacked column chart 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
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
ProductX 2
@ excel table 2
"Hierarchies" 2
DAX AVERAGE 2
Chart Visualization 2
Security 2
R 2
Reporting 2
Connection 2
automation 2
refresh data 2
power bi visuals 2
Managing Roles 2
Dynamics CRM 2
Total Sum 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
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
"CHART" 2
Measure Help 2
drill down 2
Groups 2
Strings 2
UserName 2
Shape Map 2
delete rows 2
Replace Values Based on Another Column 2
fill empy cell 2
yield 2
reference 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
interpolation 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
compare row value. 2
Request 2
loading 2
link 2
Icons 2
Events in progress 2
Turnover 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
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
"Expression" 2
"Tutorials" 2
Excel formula to Dax 2
Content 2
Quick Tips 2
database 2
outliers-detection 2
selection 2
Sum on a dynamic date range 2
percentiles 2
Summerizecolumn 2
fiscal period 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
RollingForecast 2
Rolling attrition 2
Waterfall 2
Dax_Functions 2
% of sales 2
holiday 2
Different Fiscal month 2
subcategory 2
FIRST 2
multiple conditions 2
Asking help 2
Neep Help 2
"SEQUENCE" 2
Dax Studio connection error 2
"Filters" 2
dax code for calculated measures 2
GUID 2
RemoveFilter 2
Custom Visuals 2
axis 2
Missing data 2
dropdown 2
Age 2
Data Analysis 2
new measure of % by group 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
Disconnected tables 2
DynamicMeasure 2
medianx 2
coordinates 2
hourly calendar 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
"Prior Month" 2
Linear Regression 2
DAX for dynamic difference calculations. 2
measure filters 2
Map 2
BI 2
Streaming Datasets 2
Latest Date 2
dependency 2
KPI Indicator 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
Tips &Tricks 2
@100% stacked bar chart 2
IRR 2
dinamic 2
hint 2
Power BI Calendar Tables 2
DAXformula 2
Conditional use of measures 2
bucketing 2
Legends 2
"Format" 2
"multiple criteria" 2
portfolio 2
targets 2
New Help 2
Filter Changes 2
sumtotal 2
grouped 2
Custom calendar 2
30 2
coalesce 2
Selections 2
date hierarchy 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
Dynamic slicer 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
@Power BI Report Builder 2
DAX compare similar past period 2
@Parameter 2
"VALUES" 2
Visual Calculations 2
gateway 2
date slicers 2
Power BI Data 2
gauges 2
filter pane 2
searching from 2 tables 2
weekdays 2
custom formula 2
Substract with a measure 2
categorization 2
ageing AP & AR 2
runningtotal 2
% share 2
progress 2
DAX count 2
Max per Category 2
Want to create a calculated column 2
interactive visuals 2
many-to-many 2
help dax 2
@WeekName 2
"Maxdate" 2
dax measure error 2
CUSTOMCOLUMN 2
Formula with Multiple Conditions 2
Mysql 2
User 2
t 2
Visual Studio 2
many to many relationship issue 2
Multiplying by Sum 2
TOTALYTD through Today 2
Cumulative sum partition 2
addcolumn 2
return 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
select date 2
Filtered table 2
Mesasure 2
optimisation 2
Active Customer by Month 2
% difference 2
Inventory Management 2
Hours 2
CalculatedColumn 2
PowerBI Forecasting 2
@Calendar 2
Dax formaula 2
Average of value at filter date and specified or previous year-end date 2
"Contoso" 2
Paginated Reports 2
Benchmarking 2
data model issue 2
Hierarchy slicer 2
FX 2
Margin 2
Date Comparison 2
calculate Percentile 2
EARLIEST 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
Gross Profit % 2
modelling 2
DAX Cumulative Filter 2
Maximum value 2
"Dashboard Design" 2
% Growth 2
ignore 2
Semantic model 2
New Challenge 2
error message 2
Grouped field 2
Expertise help 2
Stock Valuation 2
dynamic column names 2
weighted distinct count 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
Excel formula 2
FILL DOWN IN DAX 2
equals 2
Prior Year 2
"Time Zone" 2
ranking multiple criteria DAX 2
USERPRINCIPALNAME 2
Many to One Relationship 2
@Measures 2
"Lines Chart" 2
Salesforce 2
live dashboards 2
1 2
Edit In Power BI Desktop 2
Match 2
Extract 2
Summarize() 2
Group total 2
Likert scale 2
"error" "reports" 1
dyanmic 1
Hierarchy of Slicers 1
available time 1
List sorting 1
POPL 1
PowerPoint 1
busqueda rangos 1
dynamic field 1
comapring 1
help fix 1
Dinamyc index 1
worngvalues 1
Roll 1
cumulative count with independent date tables 1
Branching 1
Reverse Slicer 1
Total No of Days Spent month wise breakup using Time Periods 1
Visual Display issue 1
Matrix grouped columns issue 1
Dynamic age column 1
multi-row calculations 1
fill do 1
IsOnOrAfter 1
@Accumulate 1
many-many 1
Top5 per category 1
week of month 1
Puzzle 1
Need Measure 1
Live Report on Power BI Services 1
STLY 1
Teacher 1
CPU consumption 1
notcontains 1
disconnected table 1
cumulative percentage by week 1
MEDIDAS 1
Like Command 1
AES 1
Dynamic Role 1
sensitive data 1
Demand 1
night day time comparison 1
Porcentagem Acumulada 1
@fact 1
Weekend 1
"bug" 1
What If Date 1
semi additive measure 1
custom viz 1
Networkday 1
work 1
transition 1
@ssrs 1
rolling 3 months average 1
near value 1
TOTAL IN THE LAST PERIOD AND SUBTRACTING THE VARIANCE FROM PRIOR PERIODS 1
Days in stock 1
current week filter 1
Prior 1
Filter Function 1
no effect 1
purchase after initial purchase 1
tally 1
Payroll Projections 1
Dynamic arrows 1
Slicer values 1
Dropdown Slicer 1
stock transfer 1
"pbi" 1
null values 1
double 1
occupancy 1
matched pairs 1
CircularDependancy 1
Startofweek 1
WorkingDays 1
D 365 Sales 1
Event Occurence 1
previous day 1
Important 1
replace values 1
7D AVG 1
"Spanish" 1
"Categories" 1
"Objetos Visuales" 1
workforce analytics 1
Hard 1
schedule 1
Power Bi Reports 1
external users 1
Dynamics 365 1
123 1
Dataflows 1
iamprajot 1
Power Apps 1
Unhandled 1
changing classifications 1
Share Valuation 1
financial data 1
SPC DAX XMR chart Control limits 1
Nonlinear Regression 1
'SYNTAXERROR' 1
Ties 1
Line & Stacked Column 1
Help to update datasource 1
Relations management 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
one-many 1
cagr 1
Combine two column 1
filtered text column 1
clear all filters 1
Community Services 1
cumulative totals by category and date 1
Investment return 1
Rolling Average 7-day 1
Healthcare 1
Student 1
pbi dax 1
Drawdown 1
total values 1
data parsing 1
cummulative count 1
RollingTotals 1
not equals to 1
Supply 1
used 1
Otimização DAX 1
MoS 1
Correcting subtotals 1
PARITIONBY 1
items within orders 1
second largest 1
Nearest value based on other columns values 1
medida 1
Value of transaction 1
Page Level Filters 1
u 1
ACC 1
need help in power query 1
visual card 1
campaign behavior 1
Show what filters are applied on the page 1
quick measures 1
custom arrows 1
Relational Table 1
DiretQuery 1
"dinamically" 1
Employee Exit 1
Accessing Tables 1
Date cal 1
Visualise differences 1
Learn Together 1
USERELATIONSHIP DAX Measures 1
codition 1
Need Nelp! 1
Sales Analytics for Dynamics Sales 365 1
Tips needed 1
Visual Table 1
Help please! 1
for each loop 1
Query Time 1
'Pivot' 1
"Español" 1
bars 1
summarizecolumn 1
Summarize Columns 1
drill through a measure 1
employee metrics 1
@power bi dax 1
Cards 1
Embed 1
delete 1
Test 1
Active Directory 1
Schedule Refresh 1
Sync Slicer 1
slicer value used in a different way 1
Data Security 1
scatterplot 1
ovetteabejuela 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
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
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
Matrix Subtotal 1
renewals 1
Daily average cases 1
Percentil 1
ABS 1
conditional measure 1
Quiz 1
Calculate slicer 1
Time Projection - 5 Years 1
Retirement Age 1
Curve 1
newcustomers 1
Wrong total 1
going 1
side by side comparison 1
active tasks 1
instance 1
Short 1
kpi card 1
Coverage 1
AvgTopN 1
FV 1
Tips and tracks 1
statement 1
Scatter 1
Merge Tables 1
stacked 1
Data Validation 1
Power Bi Slicer 1
Duration conversion 1
condición 1
PowerBI _ les filtres dans les mesures 1
scrollbar 1
average measure 1
generateall 1
dax counter measure 1
Total sales by fisical date 1
accumulated 1
Pop-up 1
ASCENDING 1
Need your support @RLS 1
static 1
Filters on Power Bi page 1
Granularity 1
Replicate or Duplicate same value in all rows till we find a revenue. 1
"Current time" 1
SKIP 1
disable Interactions 1
filter propagate 1
power bi bar graph averages 1
average as grand total 1
Percenatage 1
dynamic reference 1
along time 1
NEGATIVE HOUR 1
NAMEOF 1
@ssrs report builder help 1
Download Semantic Model 1
hints needed 1
@SQL 1
WebContent 1
dax meassure same row different column 1
inverted 1
"ISINSCOPE" 1
calculate rows 1
DateDim 1
Excluding values 1
detailrows 1
Power BI Field Parameters 1
"DAX" "Need help" "Weekly KPI" 1
Point-in-Time 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
v-qiuyu-msft 1
helps 1
Custom Time Period for Dataset 1
Icon Formatting 1
transformation 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
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
Number 1
Monthlt ratios 1
date filters 1
Rolling Average Quarterly 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
Parent Column 1
average by month 1
USERPRINCIPLENAME 1
next period 1
PY Calculation 1
User Actions 1
end of month 1
DAX factor based on date range lookup table. 1
Window Functions 1
Lord knows... 1
esay one 1
biggest 1
negative filter 1
multiple selections 1
calcualtetable 1
SUBSTR 1
Vertipaq 1
Dynamic Dates 1
best match 1
dynamic time range insight 1
Dataverse DAX 1
System Out Of Memory 1
multiselection slicer 1
Value for last month of Quarter for multiple selection filter 1
AVERAGE BY DAY 1
lost 1
Count if 1
CountIFS to Dax 1
@createtable 1
date time format 1
Time Filtering 1
Filtercontext 1
% change between dates 1
new measures 1
Extreme weather 1
Best Practices 1
Roundup 1
Roles 1
Embed Report 1
scale 1
SQL Server Database 1
repeated 1
links 1
D3 1
row_number 1
child objects 1
correct visuals 1
total zero 1
bad data 1
in chosen periods 1
title 1
azure devops 1
Denominator 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
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
BI Views 1
Shadow Filter Context 1
Return Recent with exception 1
filter table based on slicer 1
SELECTEDVALUES 1
code optimization 1
dates range 1
sum if 1
many to many relation ship 1
multiple substraction 1
"multi-value" 1
zero value 1
count dup 1
rolling count 1
smallest 1
Help with conditional formatting 1
"pivot table" 1
@quartiles 1
MID 1
duplicate to future periods 1
graficas 1
lastweek 1
Currency sign 1
single value slicer 1
filldown 1
tree 1
"Loop" 1
Future Month 1
active count 1
pre selected filter 1
@Linestx 1
reuse 1
fte 1
DAX SUMX Measure 1
threshold 1
Version Control 1
outlier 1
Data Source 1
timeline slicer 1
numbers 1
default 1
logs 1
. 1
incorrect 1
[help needed] 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
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
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
History trend 1
Equations 1
Dynamic data selection 1
Max value 1
data label 1
SUMIFS_PowerBI_DAX 1
PowerAutomate 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
disconnected date slicer 1
Filter Contex 1
"create Table wit a distinct row with condition" 1
Sum Total Visible Table Fiscal Calendar 1
Unable to get correct values 1
Measures Drill Through 1
"DAX" "SUM" "UNIQUE" 1
correlation 1
Idea 1
Power BI App 1
PowerShell 1
reporting services 1
historical 1
Solution 1
PBI Report 1
Power BI dataset 1
Company Average 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
Previous Date 1
dynamic percentage calculation 1
Alternatives for AverageX 1
Day on Day 1
using 1
multiple join 1
ISNUMBER 1
12 hour 1
@redshift 1
background color 1
static value 1
List value account 1
Mongodb 1
Workout Wednesday 1
array 1
order time 1
FPY 1
Change Default Setting 1
rolling 12 month 1
Suma del promedio 1
hide blank 1
Column Number 1
more than 2 tables 1
Fill 1
Image in DAX 1
Velocity 1
DMV Query 1
@Incorrect slicer date showing 1
Conditio 1
plan values 1
Year to week 1
longitudinal 1
duplicaterows 1
Powerbi Report Builder 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
hours overdue 1
distinct values 1
matriz 1
Recurring 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
multiple selection 1
active per month 1
Dynamic Slicers 1
LINESTX 1
dropdown menu 1
DAX function HELP 1
self join 1
"Date and Time" 1
Achievement 1
users 1
Pro Trial 1
Image URL 1
Analyze in excel 1
running-totals 1
CSV 1
Validation 1
Forex 1
where 1
% complete 1
Parameter formatting 1
MAQ 1
timeline report 1
Transaction 1
one inn many 1
powerbi forum - 1
Color Map 1
Refresh dataset 1
Excel attachment 1
model view 1
Error due to relationship 1
have a 1
mailto 1
Realtotals 1
consolidation 1
a da 1
one slicer to filter another table 1
24 hour 1
predictive models 1
Measure name change based on year selected in Slicer 1
NoData 1
FirstPass 1
leapyear 1
Score an account 1
% of total 1
Decile Rank 1
BOM 1
row based measure 1
past week 1
syncing 1
partial text 1
replacenullvalueinmatrix 1
New Member 1
YTW 1
Nested Filter 1
DAX _ Moving Average 1
percentage of row total 1

Join us at the 2025 Microsoft Fabric Community Conference

Join the discussion

Pareto rule for multiple columns

Running Total by Count of Action - Pareto Chart

Helpful resources