Join the discussion

Create unique ID from transaction number if no ID ...

by on Latest post on by

3 Replies 143 Views

3 Replies

143 Views

New column based on fixed amount

by on Latest post on by

5 Replies 162 Views

5 Replies

162 Views

Transponer valores de filas en columnas en una tab...

by on Latest post on by

4 Replies 151 Views

4 Replies

151 Views

Get min and max value in column to display age in ...

by on Latest post on by

3 Replies 201 Views

3 Replies

201 Views

Subtract Measure Values from Column

by on Latest post on by

3 Replies 189 Views

3 Replies

189 Views

Search if statement with multiple conditions

by on Latest post on by

1 Reply 133 Views

1 Reply

133 Views

Insert a limit in a measure to avoid below 0 or ab...

by on Latest post on by

1 Reply 126 Views

1 Reply

126 Views

FILTER text column to only return text results

by on Latest post on by

2 Replies 160 Views

2 Replies

160 Views

Helpful resources

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