Join the discussion

Is this a bug or something? (Using IF, HASONEVALUE...

by on Latest post on by

2 Replies 104 Views

2 Replies

104 Views

Weekly aggregations not picking up appropriate dat...

by on Latest post on by

1 Reply 87 Views

1 Reply

87 Views

Calculate average working days between two dates, ...

by on Latest post on by

4 Replies 1761 Views

4 Replies

1761 Views

Helpful resources

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