DAX Commands and Tips

Join the discussion

Chart with last 4 weeks' data and secondary chart ...

by on Latest post on by

1 Reply 254 Views

1 Reply

254 Views

Creating Week Over Week View

by on Latest post on by

3 Replies 649 Views

3 Replies

649 Views

Need a formula to produce overall average per week...

by on Latest post on by

1 Reply 200 Views

1 Reply

200 Views

calculate value for previous week of the month

by on Latest post on by

3 Replies 1342 Views

3 Replies

1342 Views

Dynamic 13 weeks based on WEEK SELECTION [DD-MM-YY...

by on Latest post on by

1 Reply 3109 Views

1 Reply

3109 Views

Helpful resources

DAX 3,863
Need Help 2,949
"DAX" 509
help 427
DAX Calculation 413
"Need Help" 325
Need Help DAX 324
Filter 321
Measures 291
"DAX help" 283
measure 276
Tips and Tricks 252
Help Requested 237
CALCULATE 229
Power BI 227
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
Slicer 132
Help me 132
@Dax 128
@Dax help 122
RANKX 111
DAX Measures 111
Tutorial Requests 110
SUMMARIZE 109
Help with DAX 105
DAX Commands 103
Help required 101
Help Request 95
"DAX " 95
powerbi 88
Time Intelligence 86
sum 85
average 84
"Help" 82
Table 77
@dax @help 76
Power Query 75
dates 74
@Daxhelp 74
DAX help needed 71
@NeedHelp 71
DAX Query 70
matrix 69
Calculated columns 68
if 67
POWER BI Dax rules 67
DATEDIFF 67
COUNTROWS 61
sumx 60
"MEASURE" 59
LOOKUPVALUE 59
Filters 56
Formula 54
Conditional Formatting 52
TopN 52
"CALCULATE" 51
"Calculated Column" 51
calculated column 51
"DAX Commands and Tips" 50
Help with DAX Measure 49
Matrix Visual 47
"DAX " "DAX help" 'Need help' 'DAX' 47
help needed 46
"Power BI" 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
Get Help 37
distinctcount 37
RLS 37
all 36
running total 36
Power BI Desktop 36
ALLSELECTED 36
percentage 35
Filtering 35
MAXX 35
Distinct Counts 34
Filter context 34
if statement 34
YTD 34
ALLEXCEPT 34
divide 33
@Power BI 33
DATEADD 33
switch 33
rank 33
groupby 32
PowerBI Desktop 32
'Need help' 'DAX' 31
@Please Help 31
@Dax Measure Error 31
Group By 31
ranking 31
DAX Filtering 31
DAX ALL PowerBI Excel 30
Hierarchy 30
Running Totals 30
values 30
slicers 29
DAX Power BI 29
Distinct 29
@help 29
"beginner asks Help" 29
Switch() 29
Data Modeling 28
"dax code" 28
DAX Command 28
dax formula 28
USERELATIONSHIP 28
column 28
Cumulative Sum 28
datesbetween 27
EARLIER 27
Urgent Help with DAX 27
needhelp 26
Excel 26
Virtual Table 26
SUMMARIZECOLUMNS 25
Measure Column Total 25
DAX FILTER 25
All() 25
total 25
Aggregation 25
Visual 25
tables 25
Dynamic 24
Calculatetable 24
Compare 24
Tips & Tricks 24
"DAX help" DAX 24
Interesting Links 23
" Slicer" 23
REMOVEFILTERS 23
Power Pivot 23
blank 22
Totals 22
DAX tips 22
calculated table 22
Data Protection 22
Calculated Measures 22
Date and Time 21
@need help 21
@measure 21
CONCATENATEX 21
VAR 21
Cumulative Total 21
relationships 21
DAX RANKX 21
calculation 21
variables 21
error 20
Month 19
DAX. CALCULATE 19
Format 19
time 19
averagex 18
calculation groups 18
@Conditional Formatting 18
min 18
Urgent Help 18
MTD 18
Forecasting 18
lookup 18
"RANKX" 17
if condition 17
Formula Help 17
cumulative 17
Need Dax 17
"Dates" 17
SQL 17
average of a measure 17
calendar 17
Dax commands help 17
DAX Time Intelligence 17
Need Help -DAX Measures 17
chart 17
related 17
"Time Intelligence" 17
CONTAINS 16
MAX date 16
"DAX " "DAX help" 'Need help' 16
Tips 16
dax functions 16
Top N 16
Cumulative Calculation 16
Sameperiodlastyear 16
PowerBI Community 16
Circular dependency 16
Line chart 16
index 16
card 16
Dax studio 16
Date Table 16
Field parameters 16
conditional 15
Table Visual 15
"DAX" "Earliest date" 15
columns 15
@powerbi 15
KPI 15
Calculations 15
Running totals and cumulatives 15
Need Urgent Help 15
duration 15
Need help (Using direct query) 15
DAX SUMMARIZE 15
COUNTX 15
Urgent 15
value 15
If statements 15
Need Help in Power Bi 15
forecast 15
SAME PERIOD LAST YEAR 15
Need help with DAX 14
Matrix Visualisation 14
context 14
DAX Averages 14
Direct Query 14
Slicer Visualizations 14
Related Tables 14
DAX Direct Query 14
DAX SWITCH 14
help in dax Function 14
"CALCULATETABLE" 14
DAX For Filter 14
crossfilter 14
DAX function 14
POWER BI DATA VİEW 14
PowerQuery 13
concatenate 13
Optimizing DAX 13
LASTNONBLANK 13
sort 13
Duplicates 13
Difference 13
Need DAX Help 13
question 13
AND 13
CUMULATIVE COUNT 13
Cumulative Totals 13
variable 13
Tutorial 13
@measure filter 13
"Date Table" 13
relationship 13
Date measures to filter data. 13
Performance 13
DAX BUG 13
Sumx() 12
Matrix table 12
Text 12
DAX Data Table 12
"Calculation Group" 12
'Need help' 12
TOTALYTD 12
rows 12
weighted average 12
minx 12
column calculation 12
condition 12
"average" 12
WEEKNUM 12
Tip & Tricks 12
Rankx with filter 12
Dashboards 12
Commands and Tips 11
needs help 11
Calculation Group 11
VLOOKUP 11
blanks 11
Row Level Security 11
sorting 11
percentages 11
Formatting 11
Visuals 11
subtotal 11
DAX Date condition 11
join 11
Slicer based on calculated Measure 11
Advance DAX 11
date slicer 11
function 11
Variable calculation 11
RANKX issue 11
Filter Table 11
DAX&Power Query 11
pareto 11
SUMIF 11
Measures to filter out 11
CONTAINSSTRING 10
Year 10
time functions 10
COUNTIF 10
Median 10
grouping 10
datesinperiod 10
Last date 10
DAX Syntax 10
DAX Optimization 10
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
Dynamic Ranking 10
How To 10
Rolling 12 Months 10
sales 10
budget 10
currency conversion 10
Currency 10
Search 10
Moving average 10
General 10
Data Modelling 10
new column 9
grand total 9
subtotals 9
group 9
parameters 9
dynamic table 9
date calculation 9
Dynamic Date Period 9
SSAS Tabular 9
Countdistinct 9
Report 9
Tableau 9
DAX Hierarchy 9
Switch Metric 9
Previous month 9
context transition 9
Nead Help 9
Performance Issues 9
Loop 9
keepfilters 9
CALENDER 9
ADDCOLUMNS 9
Power BI Help 9
@PowerQuery 9
category 9
SUM based on some filter 9
@DateTime Functions 9
Data model 9
bar chart 9
CountIfs 9
Weekday 9
IF Functions 9
M 9
isfiltered 9
measure based on slicer 9
query 9
PowerBI Help 9
Parent child 9
row context 9
PowerBI DAX 9
DAX SUM 9
COUNTA 8
COLUMN VALUES 8
.DAX 8
previous year 8
legend 8
target 8
Year to date 8
Average Grand Total 8
ORDER 8
TREATAS 8
tabular 8
Filter Multiple Column 8
QTD 8
Need Help - Goals 8
LastDate 8
Row 8
@get help 8
"DAX create dynamic table from slicer date" 8
"Power Pivot" 8
"Date" 8
'DAX' 8
Standard Deviation 8
"Power Query" 8
firstdate 8
INACTIVE RELATIONSHIP 8
Groupings 8
SSAS 8
FILTERS DAX KEEPFILTERS 8
Dynamic RLS 8
SQL to DAX 8
Merge 8
MoM 8
rolling 8
Time interval 8
OR 8
Calculate function with multiple criteria 8
what if parameters 8
Clustered Column Chart 8
crossjoin 8
" Error Handling" 8
distinct count 8
Conditional Formula 8
Reports 8
Year over Year 8
custom column 7
date filter 7
Multiple columns 7
exclude 7
Categories 7
Between dates 7
today 7
Many to Many Relatioinship 7
multiple tables 7
relatedtable 7
Advanced filtering 7
Iterator 7
unpivot 7
DAX ALLSELECTED 7
subtract filtered value 7
calculated tables 7
Filter Multiple Columns 7
"SELECTEDVALUE" 7
beginner 7
churn 7
@ Matrix Visualisation Error In Calculation 7
isinscope 7
rolling sum 7
"DAX Query View" 7
"Tips and Tricks" 7
Regression 7
Last Year 7
Tabular Model 7
IF AND with multiple conditions 7
powerpivot 7
drill through 7
Table Column 7
aggregate 7
cummulative 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
multiple column 7
union 7
Inventory 7
syntax 7
segmentation 7
weekly 7
conditional column 6
dax problem 6
"MAX" 6
color 6
Need Info 6
COUNTAX 6
rolling average 6
isblank 6
"Dynamic Slicer" 6
Variances 6
variance 6
Data Type 6
Calculated Measures Only 6
Networkdays 6
string 6
DAX Total 6
DAX code 6
graph 6
Waterfall Chart 6
ID 6
dates table 6
DAX Max Date within date range 6
Filter using a measure 6
snapshot 6
selected value 6
dax tip 6
tooltip 6
Average from Matrix 6
Duplicate data 6
dynamic filter 6
pivot 6
change 6
"VAR" 6
Visualization 6
Maxdate 6
DAX TOPN 6
@visual level filter 6
SharePoint 6
Power 6
Headcount 6
Percentage Difference 6
"COUNT" 6
percentile 6
previous 6
Summary 6
i need help 6
Show & Tell 6
Month Calculation 6
In 6
Filter based on context 6
sumifs 6
Latest 6
Intersect 6
Divide Function 6
Calendar Table 6
"FORMULA" 6
data 6
PBI Desktop 6
column selection 6
recursive 6
PBI 6
IF ELSE 6
CALENDAR() 6
Division 6
matrix calculation 6
optimize 6
Visual Filtering 6
duplicate 6
Conversion 6
comparison 6
Total not matching 6
ADDCOLUMNS() 6
dates between 6
RLS problems 6
previousmonth 6
Nee help 5
Need help. 5
Questions 5
tricks and tips 5
CODE 5
Path 5
Dax performance 5
Need Hepl 5
New Table creation 5
DAX Performace 5
"help" "targets" "tables" "Related" 5
Help using powerbi 5
line graph 5
SVG 5
MIN date 5
Chart Help 5
Dynamic row level security 5
measures in calculated columns 5
status 5
tutorial request 5
maximum 5
charts 5
need helps 5
"Grand Total" 5
"TOPN" 5
date format 5
cumulative value 5
Total wrong 5
Need a help 5
dax variable 5
Measure Totals 5
Custom Measures 5
commands 5
pivot table 5
Statistics 5
Modeling 5
Gantt chart 5
max date problem 5
Desktop version 5
profit and loss 5
Subtract 5
DAX TABLE 5
Average Rates 5
Dax Power Pivot 5
daxhelp 5
Add Column 5
Pie Chart 5
" cumulatives" 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
Conditional Sum 5
Hierarchical slicer 5
conditions 5
Week time intelligence 5
Working Hours 5
distribution 5
i 5
Dynamic Flag 5
datesytd 5
"SWITCH" 5
graphs 5
new measure 5
calculate columns 5
yoy 5
rolling 12 5
Unique Value 5
replace 5
@ 5
Calculate Sum 5
"Data Model" 5
mdx 5
running balance 5
context filter 5
conditional columns 4
dax calculations 4
"subtotal 4
PREVIOUSDAY 4
Customer 4
Dynamic Column 4
date range 4
Rolling Months 4
Histogram 4
summarize table 4
Tabular Editor 4
calculated 4
Dynamic filters 4
Rolling Averages 4
Growth 4
Gauge 4
What If 4
Security roles 4
WOW 4
Runnig Total 4
@average 4
"Time" 4
update 4
previous week 4
Fiscal Year 4
rolling dates 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
Measure Multiplication 4
Cumulative Totals by category 4
Average Sales 4
multiple filters 4
Split column 4
Weekday calculation 4
Functions 4
advanced dax 4
Dashboard 4
weighted 4
cumulative total - running total 4
bridge table 4
Conditional Totals 4
Issue 4
tickets 4
DATESYTD Help needed 4
cumulative sum by category 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
multiple rows 4
opening balance 4
HASONEFILTER 4
working days 4
IF THEN ELSE 4
stacked bar chart 4
count rows 4
Custom Visual 4
metric 4
bar charts 4
First Value 4
SCD2 4
DATESMTD() 4
Average by other column 4
@slicer 4
Quarter 4
Product 4
status change 4
relations 4
Direct Query mode 4
holidays 4
If Then 4
expression 4
AVG 4
Average of a result 4
Query Editor 4
Dimension 4
growth rate 4
BINS 4
Date Calculation Error 4
New Table 4
HR 4
Workday 4
fiscal 4
Rolling AVG 4
dynamic title 4
IF = BLANK() 4
DAX ROW CONTEXT 4
TopN Customer 4
SLA 4
metrics 4
weekly-averages 4
employee 4
Null 4
Dynamic Index 4
WTD 4
Quarter over Quarter 4
NOT 4
Total Measure 4
Earlier Function 4
Power Query Editor 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
Composite Model 4
Total wrong in matrix 4
utilization 4
Custom Filter 4
stock 4
Conditional Formatting column 4
Conditional measures 4
"if statement" 4
Visualisations 4
range 4
Advanced Visualization 4
% 4
OR function 4
salary 4
Calculatetable filter 4
DAX Relationships 4
monthlyaverage 4
Dax_Help 4
YoY calculation 4
"Calculated Columns" 4
"powerbi" 4
finance 4
tutorials 4
multiple 4
selected values 4
hasonevalue 4
result 4
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
e 3
Max date from select dates in Dataset 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
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
dax mode count 3
calculated rows 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
recursion 3
complex dax 3
@divide 3
"Power BI Report Server" 3
R script 3
guidelines 3
relative date filtering 3
column total 3
custom 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
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
SUM of Units 3
unique 3
Power Automate 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
Azure Analysis services tabular model 3
Absolute Value 3
active customers 3
PBIX Reports 3
column formatting 3
Difference Between Dates 3
0 3
DAX Date Table 3
Need help! 3
Python 3
Calendars 3
start 3
Field Value 3
cumulative percentage 3
count distinct with condition 3
Ignore Slicers 3
help with date 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
BI Vs Tableau 3
Lookupvalues 3
empty columns 3
Userrelationship 3
DAX table filter 3
Previous row value 3
ratio 3
List 3
time calculation 3
Conditionals 3
@Cummilative 3
dynamic data filtering 3
normalize 3
Dynamic data selection based on date 3
facts filtering dimensions 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
Flow 3
benchmark 3
complex 3
Text Measure 3
Analysis in Excel 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
Calculate function 3
" Time Intelligence" 3
Retention 3
XLOOKUP 3
Except 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
negative 3
Counter 3
DAX for max utilisation 3
financial report 3
Find multiple values 3
firstnonblank 3
attrition 3
DAX. 3
Fiscal Calendar 3
minimum 3
support 3
Count rows (date) by month 3
SUM of MAX 3
Day of Week 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
Dax Join 3
Visualizations 3
"aggregations" 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
New customers 3
Analysis 3
line chart visual 3
M language 3
circular 3
incorrect total 3
Backlog 3
monthly growth 3
Date Function 3
@FORMAT 3
visual level filter 3
API 3
Filter two tables 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
"Totals" 3
Calc column assistance 3
two tables 3
date interval 3
Column Chart 3
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
"Lines Chart" 2
portfolio 2
targets 2
New Help 2
Filter Changes 2
weekdays 2
custom formula 2
Substract with a measure 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
"DAX create dynamic table from slicer " 2
"Running Total" 2
gateway 2
date slicers 2
Power BI Data 2
gauges 2
filter pane 2
searching from 2 tables 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
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
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
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
data model issue 2
Hierarchy slicer 2
FX 2
Margin 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
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
Grouped field 2
Expertise help 2
Extract 2
Summarize() 2
Group total 2
Likert scale 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
Salesforce 2
live dashboards 2
1 2
Edit In Power BI Desktop 2
Match 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
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
Measure Help 2
Business 2
queries 2
Analysis Service 2
radar chart 2
else 2
Sparkline 2
slow rendering 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
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
sankey 2
while 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
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
SAP 2
date ranges 2
multiple date tables 2
credit 2
Cross-Filtering 2
Line and stacked column chart 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
Region 2
combine 2
mappings 2
Assigning Roles 2
Dynamics CRM 2
Total Sum 2
Custom Date Range on Date Slicer 2
expressions 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
Security 2
R 2
Reporting 2
automation 2
refresh data 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
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
"multiple criteria" 2
drill down 2
Groups 2
Strings 2
UserName 2
Shape Map 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
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
Icons 2
Events in progress 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
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
Content 2
Quick Tips 2
database 2
outliers-detection 2
selection 2
Sum on a dynamic date range 2
Data Analysis 2
new measure of % by group 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
Average of value at filter date and specified or previous year-end date 2
"Contoso" 2
Custom Visuals 2
axis 2
Missing data 2
dropdown 2
Age 2
dependency 2
KPI Indicator 2
Past & Current Month Latest data 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
Map 2
Paginated Report 2
BI 2
Streaming Datasets 2
Latest Date 2
sumtotal 2
grouped 2
Custom calendar 2
30 2
coalesce 2
Selections 2
date hierarchy 2
Productivity 2
not display data 1
507 AE 990 AEDU 201 AEM 4 1
annual 1
DAX formulas for total quantity matching 1
Previous Week comparison 1
Customer Revenue Comparison 1
PowerBIDesktop 1
invoice 1
by group 1
interaction 1
cumulative distinct count 1
Needl Help 1
overdue 1
number to text 1
MULTIPLESELECTION 1
DATA DON'T LOAD 1
true() 1
DateTime Math 1
Nextyear 1
Transactions for filtered customers 1
IMR 1
add up 1
formatting cells 1
Decimal 1
DAX for %ROI 1
Random numbers 1
azure maps 1
damage percentage 1
Minus 1
Inventory Deduction 1
Two dates 1
outliers 1
advice 1
@api 1
multidime 1
ValidFrom 1
target store 1
dat 1
Custom Visuals Development Discussion 1
line cart 1
Quick Help Tip 1
|| 1
fixed value 1
optimisation 1
rate 1
Home Page 1
Net Changes 1
area chart 1
year-over-year 1
@related 1
Overlapping 1
per employee 1
Time Delta calculations 1
distribute amount 1
100 1
variable length 1
Fortnightly 1
fiscal month 1
Pattern 1
tips format 1
like the image 1
inventory value 1
running count 1
average count 1
Custom table 1
call center 1
Find % Of Total lines with Specific Filtered Applied 1
age labels 1
summarizing 1
Special Dates 1
CASEWHEN 1
slicer by measure 1
Customer purchase behavior 1
filter on tooltip 1
Card (new) 1
redeployment 1
anual growth rate 1
Group by measure in colum 1
Inheriting 1
processing 1
except() 1
Fact Tables 1
Week-to-date 1
Vlookup Dax Help 1
Crear Tabla DAX 1
Direct Query Performance DAX Measure 1
Price effect 1
IFStatement 1
Longer Week 1
DAX Issues 1
@Measures 1
weekly sales 1
"% Increase" 1
parame 1
average percentage per week 1
workforce analytics 1
tile 1
R in Power Query 1
RankX issue with RLS 1
Permissions 1
Report server RLS row level security 1
category names 1
Data Mashup Error 1
Data Flows 1
scheduled 1
Video 1
imported 1
cube 1
loop up values from 2 tables 1
count 0 and 1 1
F 1
&& 1
INCORRECT CALENDAR 1
usage metrics report 1
Multiplication and wrong total in table 1
40 1
I need t 1
resets if 0 1
subtotal in a row 1
395 AEMD 2 1
conditional replace 1
hI i 1
Rolling inventory in each month associated with SKU 1
@countifs functionality @Need Helop 1
problem 1
14 day 1
completed 1
Preview Features 1
Last N Months Data 1
running a Query with two tables to show each row 1
QTR 1
Filter Pane Search 1
unique id 1
smoothing 1
help with hiding subtotal 1
Scenario Analysis 1
SUBSTITUTE 1
Workdays 1
Security Model 1
Need help on to the dataset id using filters 1
summerize 1
PowerBI calendar 1
write to SQL 1
Display Error 1
DAX forum 1
month by month 1
ayuda 1
to date 1
card graph 1
DAX EVENT TABLE 1
Australian Date Format 1
monthly damage devided by all year profit 1
matrix view 1
Dates not required 1
larger 1
Fact Ta 1
validTo 1
target person 1
Filling data 1
retrive data 1
Rolling Skip 1
compounding 1
allocate $ 1
nested 1
common 1
discount 1
Moving Median 1
Nested DAX 1
pleasehelp 1
LY MTD 1
dynamic parameters 1
Average of Columns With Filters 1
@microsoft 1
Day of fortnight 1
Create a table and chart for open and closed based on different conditions for past 5 months 1
DAX Pattern 1
pace 1
static total 1
Current Selection 1
average employee 1
Dynamic date display 1
Power BI Average 1
Demand Planning 1
current week 1
WINDOW 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
PowerBi Matrix 1
employee metrics 1
PostgreSQL 1
a 1
Pricing 1
Dynamic Visuals 1
themes 1
Query is too complex 1
stacked bar 1
node 1
Like for like pricing analysis 1
levels 1
Tachometer 1
evaluate total for a period for a specific column 1
dataype 1
DAX for deals added and slipped 1
50 1
ab 1
semi-additive 1
funnel 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
verting H 1
Relative Time Slicer 1
filter by date hierarchy 1
quota 1
numeric fields 1
VAT 1
recruiting 1
max several rows 1
Load Graphs 1
Multiple DAX switches and multiple slicers 1
large 1
estimation 1
eryo 1
MAX Field ID 1
Absence 1
pathitems 1
develop 1
hel 1
identical column entries 1
max number 1
Second highest 1
open API 1
table totals 1
DAX Meas 1
text comma separator 1
Calculated Flag 1
RAG 1
OVERRIDE SELECTION 1
PARRALLELPERIOD 1
count of 1
DAX events in progress 1
per day 1
Cumulative ratesame month 1
reconstructing data 1
SELECTEDMEASURENAME 1
z-score 1
years 1
data decription 1
measure slicer 1
Rolling Totals 1
Parameters switch 1
self service reporting 1
measure fromat 1
Soma acumulada 1
@relations 1
IF OR 1
"Power BI Old Version" 1
Reverse Total 1
Ranking Ties 1
"MTD" 1
Exists 1
work shifts 1
double relationship table dax 1
running totals splitted by positive and negative 1
Occupancy with Roomtypes 1
salesgoal 1
guide 1
Days in stock 1
current week filter 1
Prior 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
"DAX" "Need help" "Weekly KPI" 1
s 1
evaluation 1
quetsion 1
counts 1
Combo Chart Report Server 1
Usage Metrics in Power BI 1
ThreeYear Average 1
numbertostring 1
Filter based on Roles 1
Circle diagram 1
count of count 1
resource utilzation 1
Type 1
Combination Table 1
with filters 1
Custom Periods 1
Overlapping tables 1
Can't diplay the visual 1
headcount when have FT and PT in department 1
@time 1
Resource Use 1
data labels 1
kernel 1
Trend 1
table union measure slicer 1
sum values from specific rows to new table 1
subtotal values Matrix 1
page navigation 1
Pass Rate 1
First day of week 1
bearer 1
Defer 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
below 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
Page Level Filters 1
u 1
ACC 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
% change between dates 1
Comment 1
Google Analytics 1
Events 1
Dynamic URL Filter 1
Subscriptions 1
datasets 1
Scorecard 1
Grid 1
Power KPI Matrix 1
wildcard 1
sharepoint online 1
Outlook 1
Mean Time Between Failure 1
LLY 1
refresh button 1
pre 1
Aggregation feature 1
Premium Capacity 1
ArcGIS Map 1
veryon 1
ee 1
sclicer 1
column percent 1
scenario 1
Power BI Custom visuals 1
multiple dates 1
null value fields 1
hide 1
filter context intersection 1
country 1
Minimum AVG 1
Overlap 1
DAV 1
Comparing columns 1
Payback 1
Rate of Production 1
RLS GROUPS 1
Excel 2016 1
organizational structure 1
YTD Average 1
nested measure 1
date range. 1
Data does not display 1
matrix-empty-column 1
token 1
graphics 1
substraction 1
@Accumulate 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
linechart 1
average measure 1
generateall 1
dax counter measure 1
Total sales by fisical date 1
accumulated 1
Pop-up 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
"PYTD" 1
Count if 1
CountIFS to Dax 1
@createtable 1
date time format 1
Time Filtering 1
Filtercontext 1
DAX SUMX Measure 1
Power BI Service 1
URL 1
key 1
role 1
share 1
append 1
KPI Matrix 1
Report Tooltips 1
export to powerpoint on premise server 1
Prediction 1
Floriankx 1
Exchange 1
help_me 1
Capital Gain 1
sql_to_dax 1
Paginated Report Builder 1
HR Analytics 1
transitive closure 1
simple 1
user access 1
fecha 1
Test as a Role 1
expand 1
"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
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
Parent Column 1
average by month 1
USERPRINCIPLENAME 1
next period 1
PY Calculation 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
Chart Visualization 1
fte 1
Measures Drill Through 1
community 1
Education 1
access 1
formating 1
Boolean 1
Counting Same Data that Occurs over Multiple Years 1
kcantor 1
ALLCROSSFILTERED 1
cross report drill through feature 1
funnel plots 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
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
disconnected date slicer 1
Filter Contex 1
"create Table wit a distinct row with condition" 1
"MATRIX" 1
Sum Total Visible Table Fiscal Calendar 1
Unable to get correct values 1
"Date and Time" 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
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
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

Be one of the first to start using Fabric Databases.

Join the discussion

Chart with last 4 weeks' data and secondary chart ...

Creating Week Over Week View

Need a formula to produce overall average per week...

calculate value for previous week of the month

Dynamic 13 weeks based on WEEK SELECTION [DD-MM-YY...

Helpful resources