skip to main content
Power BI
Overview
What is Power BI
Why Power BI
Customer stories
Data visuals
Security
Products
Power BI Desktop
Power BI Pro
Power BI Premium
Power BI Mobile
Power BI Embedded
Power BI Report Server
Pricing
Solutions
Azure + Power BI
Office 365 + Power BI
By industry
Energy
Healthcare
Manufacturing
Retail
For analysts
For IT
For developers
Overview
Embedded analytics
Power BI visuals
Automation
Documentation
Community
Partners
Overview
Find consulting services
Partner showcase
Find a partner
Become a partner
Instructor-led Training
Resources
Learn
Overview
Guided learning
Documentation
Webinars
Roadmap
Support
Overview
Issues
Give feedback
Blog
Community
Overview
Forums
Galleries
Submit ideas
Events
User groups
Community blog
More
Register
·
Sign In
·
Help
Go To
Forums
Get Help with Power BI
Desktop
Service
Report Server
Power Query
Mobile Apps
Developer
DAX Commands and Tips
Let's Talk Data
Custom Visuals Development Discussion
All community
This category
This board
Knowledge base
Users
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Search instead for
Did you mean:
Microsoft Power BI Community
Forums
Get Help with Power BI
DAX Commands and Tips
Topics with Label: bad data
Join the discussion
Options
Mark all as New
Mark all as Read
Float this item to the top
Subscribe
Bookmark
Subscribe to RSS Feed
Invite a Friend
Showing topics with label
bad data
.
Show all topics
Search across two tables, for similair data
by
ccarpent
on
01-09-2020
05:23 PM
Latest post on
01-11-2020
10:00 AM
by
ccarpent
2
Replies
217
Views
2
Replies
217
Views
Helpful resources
Top Labels
Alphabetical
DAX
934
Need Help
464
DAX Calculation
190
Measures
119
Filter
93
help
82
measure
77
CALCULATE
66
Dax Help
61
Need Help DAX
56
Power BI
54
Date
43
DAX Query
43
Help Requested
42
COUNT
42
Need Help DAX measure
42
DAX filter formula
37
Help me please
37
RANKX
36
Help required
34
Tips and Tricks
33
Time Intelligence
31
POWER BI Dax rules
30
DAX Commands and Tips
29
Calculated columns
29
Table
28
sum
27
SUMMARIZE
26
DAX Commands
24
Help with DAX
24
average
24
Help me
23
dax measure
22
if statement
21
Show and Tell
21
Slicer
20
TopN
19
dates
19
Filtering
19
if
18
DATEDIFF
17
Filters
17
Conditional Formatting
17
Help with DAX Measure
17
Formula
16
Date and Time
16
Matrix Visual
16
running total
15
help needed
14
Power Query
14
Distinct
14
PowerBI Desktop
14
LOOKUPVALUE
14
percentage
13
DATEADD
13
Desktop
13
distinctcount
13
DAX. CALCULATE
13
Get Help
13
dax functions
13
Calculatetable
12
ALLEXCEPT
12
all
12
Power BI Dax
12
calculated column
12
DAX function
12
ranking
12
Max
11
YTD
11
matrix
11
RLS
11
help in dax Function
11
sumx
11
ALLSELECTED
11
powerbi
11
Month
10
Filter context
10
values
10
Switch()
10
Measure Column Total
10
divide
10
hierarchy
10
DAX For Filter
10
Distinct Counts
9
if condition
9
SELECTEDVALUE
9
rank
9
VAR
9
Related Tables
9
Date measures to filter data.
9
averagex
9
time functions
9
Compare
9
Dax commands help
9
COUNTROWS
9
MAXX
8
tables
8
Difference
8
Cumulative Sum
8
Dynamic Date Period
8
@NeedHelp
8
datesbetween
8
switch
8
DAX Filtering
8
USERELATIONSHIP
8
Year
8
DAX Measures
7
measure based on slicer
7
time
7
column calculation
7
columns
7
needhelp
7
variables
7
crossjoin
7
Power Pivot
7
groupby
7
average of a measure
7
DAX Time Intelligence
7
value
7
DAX Direct Query
7
Urgent Help
6
currency conversion
6
slicers
6
column
6
join
6
General
6
CountIfs
6
Table Visual
6
Cumulative Totals
6
min
6
All()
6
Top N
6
Data Modeling
6
blank
6
Aggregation
6
SUMIF
6
index
6
cumulative
6
calculation groups
6
total
6
TOTALYTD
6
MTD
5
CONTAINS
5
change
5
DAX BUG
5
Visual
5
today
5
DAX ALL PowerBI Excel
5
Urgent Help with DAX
5
subtract filtered value
5
Totals
5
AND
5
context
5
EARLIER
5
DAX RANKX
5
Direct Query
5
card
5
pareto
5
Need Help - Goals
5
QTD
5
Tutorial Requests
5
calculated table
5
Matrix Visualisation
5
Group By
5
SQL
5
rolling 12
5
@Please Help
5
Virtual Table
5
percentages
5
column selection
4
Summary
4
isfiltered
4
sumifs
4
rolling
4
group
4
Need Info
4
PowerBI Community
4
Measures to filter out
4
grouping
4
variable
4
Dax studio
4
VLOOKUP
4
LASTNONBLANK
4
optimize
4
Sumx()
4
Tip & Tricks
4
dax formula
4
Year over Year
4
Date Table
4
conditional
4
COUNTX
4
datesinperiod
4
rows
4
Variable calculation
4
cumulative value
4
Average Grand Total
4
Interesting Links
4
CONCATENATEX
4
KPI
4
SQL to DAX
4
Switch Metric
4
subtotals
4
Many to Many Relatioinship
4
MAX date
4
Text
4
tabular
4
minx
4
dynamic table
4
keepfilters
4
crossfilter
4
SSAS
4
Formatting
4
Help appreciated
4
lookup
4
Calculations
4
Filter Multiple Column
4
chart
4
POWER BI DATA VİEW
4
Report
3
Dynamic
3
Performance
3
Line chart
3
averages
3
Loop
3
multiple rows
3
Data Protection
3
CUMULATIVE COUNT
3
Tips
3
color
3
selected values
3
REMOVEFILTERS
3
forecast
3
Slicer based on calculated Measure
3
SAME PERIOD LAST YEAR
3
Unique Value
3
related
3
Last date
3
ID
3
date interval
3
date calculation
3
Power BI Desktop
3
Conversion
3
dax tip
3
function
3
Optimizing DAX
3
Visual Filtering
3
SUM of Units
3
Performance Issues
3
relatedtable
3
bar charts
3
Filter based on context
3
DAX Data Table
3
PBI Desktop
3
calculated rows
3
Search
3
SUMMARIZECOLUMNS
3
Cumulative Totals by category
3
dax mode count
3
Field Value
3
context filter
3
PowerBI Help
3
Circular dependency
3
calendar
3
metrics
3
Slicer Visualizations
3
Waterfall Chart
3
Merge
3
tutorials
3
Dax Join
3
hasonevalue
3
weighted averages
3
DAX SWITCH
3
rolling dates
3
Weekday
3
@Dax
3
date slicer
3
Format
3
what if parameters
3
running balance
3
INACTIVE RELATIONSHIP
3
distribution
3
Calc column assistance
3
Need help (Using direct query)
3
Pareto Chart and table by Period help
3
Visualization
3
Standard Deviation
3
range of text
3
bar chart
3
condition
3
IF ELSE
3
Dashboard
2
Query Editor
2
yoy
2
percentile
2
e
2
complex
2
searching from 2 tables
2
budget
2
Need Hepl
2
Ignore Slicers
2
Week time intelligence
2
DAX Hierarchy
2
SUM based on existing context created by a measure
2
How To
2
cumulative percentage
2
OR function
2
grouped
2
row context
2
guidelines
2
unique
2
DAX for max utilisation
2
%
2
sumtotal
2
Search table columns for similair data
2
Direct Query mode
2
dates table
2
cummulative
2
available
2
multiple column
2
union
2
Quarter over Quarter
2
Row Level Security
2
previous week
2
Analysis Service
2
employee
2
In
2
grand total
2
tricks and tips
2
Rolling Months
2
multiple tables
2
sorting
2
SUM of MAX
2
Workday
2
conditional column
2
query
2
snapshot
2
calculated tables
2
Multiplying by Sum
2
Summerizecolumn
2
New Table creation
2
date hierarchy
2
custom column
2
partial
2
Groups
2
date format
2
Previous month
2
date range
2
line graph
2
M
2
Dynamic data selection based on date
2
WEEKNUM
2
sales
2
COUNTIF
2
day
2
Excel
2
SLA
2
dynamic filter
2
column total
2
duration
2
Events in progress
2
addcolumn
2
variance
2
FILTERS DAX KEEPFILTERS
2
Rankx with filter
2
Calculated Measures Only
2
DAX Max Date within date range
2
Countdistinct
2
Forecasting
2
Power
2
benchmark
2
previous year
2
Total wrong in matrix
2
Categories
2
SVG
2
help with date
2
Calculate function with multiple criteria
2
Iterator
2
CALENDAR()
2
New Challenge
2
mdx
2
timeline
2
combine
2
Variances
2
30
2
Userrelationship
2
Month on Month Rank Comparison
2
blanks
2
measures in calculated columns
2
Regression
2
Median
2
Managing Roles
2
Data Modelling
2
holidays
2
subtotal
2
sort formula
2
@Dax Measure Error
2
Need Help re Measure Formatting
2
NOT
2
Visualisations
2
Age
2
previous
2
Retention
2
drill
2
cumulative sum by category
2
Advanced filtering
2
@need help
2
i
2
Count rows (date) by month
2
exclude
2
concatenate
2
relations
2
General Question
2
grand total row incorrect
2
drillthrough
2
New Help
2
beginner
2
Composite Model
2
custom formula
2
unpivot
2
DAX Syntax
2
Security roles
2
selection
2
while
2
negative
2
firstdate
2
aggregate
2
Last
2
DAX Language
2
Calculatetable filter
2
update
2
Azure Analysis services tabular model
2
Max date from select dates in Dataset
2
Last Year
2
weighted distinct count
2
count distinct with condition
2
Total Sum
2
Custom Filter
2
Calander
2
Row
2
SSAS Tabular
2
General Comment
2
Reporting
2
M Query
2
Power BI Help
2
relationships
2
org chart
1
firstnonblank
1
Inventory
1
quota
1
Alias on summ
1
dax calculated
1
VAT
1
comapring
1
Data model
1
error
1
Live Connection
1
conditions
1
Expertise help
1
funnel plots
1
Object level security
1
M language
1
DATESYTD Help needed
1
ONE TABLE MODEL
1
Bundle
1
usage metrics report
1
facts filtering dimensions
1
Line and stacked column chart
1
Lowest Market Share
1
Productivity
1
pivot table
1
able
1
Day on Day
1
Realtotals
1
new calculated table
1
consolidation
1
Report view
1
conditional format
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
Mongodb
1
For Loop
1
headcount when have FT and PT in department
1
Dynamic slicer flag column
1
TopN Customer
1
data refresh
1
What If
1
Visuals
1
multiple
1
weekly-averages
1
Like for like pricing analysis
1
Floriankx
1
Visualizations
1
TOTALYTD through Today
1
changing classifications
1
product function
1
Currency
1
sql_to_dax
1
one row
1
total zero
1
Replace Text Based on Another Column
1
select all
1
DAX for deals added and slipped
1
calculate Percentile
1
Atingir Meta e Solver
1
Except
1
Rebasing
1
Row Average
1
Column Chart
1
remote computers
1
commands
1
Week
1
Previous Month Last Year Card
1
compound
1
new calculated column
1
YoY Line Charts
1
font colour
1
scalar
1
with filters
1
filter context intersection
1
background color
1
New quick measure
1
14 day
1
Overlap
1
newbie
1
predictive models
1
running a Query with two tables to show each row
1
Split column
1
DAX tips
1
Management
1
Security
1
Financial
1
Dynamic RLS
1
Fiscal Year
1
automation
1
scheduled
1
running-totals
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
like to get
1
fortnight
1
veryon
1
aaa
1
reference text
1
Total not matching
1
Top5 and Bottom 5
1
@Ranks with Trend
1
color palette
1
returns
1
hex
1
if and else
1
date filter
1
EarlierFunction
1
Concatenate columns in a measure
1
Conditional Formation Icons
1
sum vs target
1
working days
1
Case statement
1
NBA
1
Runnig Total
1
dynamic field
1
DATESMTD()
1
calculation
1
Issue
1
Query String
1
append
1
quetsion
1
node
1
Nee dhelp
1
iamprajot
1
where
1
automatic
1
Grouped field
1
by
1
Roleplaying
1
bad data
1
DAX com
1
COVID-19
1
Text Measure
1
Substract with a measure
1
return
1
scenario
1
show statusRDP
1
Moving average for measures
1
mailto
1
PRICE_NAME SUM(CALLS_SUM) AD 12
1
replace
1
DAX formulas for total quantity matching
1
Monthly percentages
1
countblank
1
Bin
1
Non Calendar FY and FQ
1
Previous Week comparison
1
multiple filters
1
Subtract
1
cardinality
1
Basket
1
record
1
Time Range
1
Questions
1
queries
1
parameter
1
Scheduled data refresh
1
tooltips
1
wildcard
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
Need to mark holidays in calendar
1
fill empy cell
1
Circle diagram
1
Group total
1
TopN by Store
1
Rolling 12 Months
1
fiscal period
1
file name
1
DAX Performace
1
BusinessCentral COA Totalling
1
remote desktop connection
1
Performance issues with AverageX
1
have a
1
subject line
1
741 ADM 14
1
annual
1
COUNTA
1
hI i
1
Path
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
TOTALMTD
1
DAV
1
related table
1
Load Time
1
Dynamics 365
1
stacked bar
1
pivot
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
Match calculated ranking column
1
INCORRECT CALENDAR
1
Line & Stacked Column
1
CODE
1
column percent
1
context transition
1
dynamic percentage calculation
1
Alternatives for AverageX
1
kpis
1
507 AE 990 AEDU 201 AEM 4
1
conditional replace
1
Parent
1
HASONEFILTER
1
SEQUENCE
1
Moving average
1
Empty
1
List value account
1
Running Total Weekly
1
time-intelligence
1
Cumulative Total
1
STARTOFMONTH
1
attrition
1
Google Analytics
1
finance
1
Embed Report
1
Gantt chart
1
need
1
formating
1
Combo Chart Report Server
1
normalize
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
"average"
1
Dynamic Flag
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
outbound delivery
1
395 AEMD 2
1
Weekly YOY
1
Combination Table
1
Child
1
POPL
1
DAX formula for tracking daily death cases
1
Merge files
1
Add "IF" before calculate
1
simulation
1
Parameter Data Type
1
month-to-date
1
Trend Line
1
NoData
1
Days
1
Model
1
Pricing
1
BUG
1
Active Directory
1
Streaming Datasets
1
numbers
1
Desktop version
1
sharepoint online
1
Sum on a dynamic date range
1
Company Average
1
LLY
1
one inn many
1
Summarize()
1
incorrect total
1
salary
1
query folding
1
20
1
coalesce
1
Selections
1
resource utilzation
1
growth rate
1
basket analysis
1
RankX excluding Some Values
1
not display data
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
weighted
1
Flag
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
invoice
1
cohort
1
KEEP
1
Tip
1
Months between
1
Salesforce
1
Please help
1
Memory
1
Quarter
1
scatterplot
1
IFNA excel funation alternative
1
levels
1
Assigning Roles
1
Parameter formatting
1
Advanced Visualization
1
FIFO
1
BI Vs Tableau
1
not equal to
1
include
1
CD and CSD
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
funnel
1
multiple dates
1
bell curve
1
LastDate
1
POP&L
1
Tag rows
1
time format
1
Current Year VS Last Year
1
cummulative dax
1
isinscope
1
Intersect
1
ADDCOLUMNS()
1
Last N Months Data
1
busqueda rangos
1
Meausre
1
Sample
1
contract
1
survey
1
Education
1
analysis services
1
Data Source
1
date slicers
1
default
1
Format Date
1
Region
1
% complete
1
Analysis
1
Stock Valuation
1
churn
1
subgroups
1
suggestions on Data Analysis
1
ORDER
1
empty columns
1
testing
1
Replace Values Based on Another Column
1
&&
1
40
1
Likert scale
1
Nominator
1
Decomposition Tree
1
DAX CALENDARAUTO()
1
Integer
1
available time
1
List sorting
1
overlaying graph
1
Combine Values
1
12 hour
1
Start and end period
1
Minimum AVG
1
SCD2
1
Quarter Issue
1
@dax @help
1
rangos
1
first per day
1
Advanced
1
interaction
1
data
1
themes
1
Scorecard
1
Urgent
1
refresh data
1
FX
1
Margin
1
graphs
1
.DAX
1
Capital Gain
1
change variables
1
pre
1
profit and loss
1
"aggregations"
1
Dimension
1
Work days
1
50
1
count of count
1
Denominator
1
expressions
1
stacked column chart
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
24 hour
1
visual filter
1
@get help
1
DATEADD Visit Windows
1
slicer calculation
1
Average from Matrix
1
Conteo
1
maxium
1
dax calculations
1
Duplicate data
1
evaluation
1
Scheduling
1
Icons
1
power bi visuals
1
Hierarchy slicer
1
Exchange
1
segmentation
1
Share Valuation
1
" cumulatives"
1
dashboard dax help
1
maximum
1
credit
1
simple
1
Access Control
1
result
1
tooltip
1
ee
1
To Show Ratio 1:2
1
conditional columns
1
resets if 0
1
Row Number in DAX
1
90
1
work load
1
customer concentration
1
conditonal formatting
1
rowlevelsecurity
1
@stock_managment
1
relationship
1
change format
1
filter by date hierarchy
1
exponent
1
ratio calculations dax
1
weeks
1
help measure
1
unico
1
Pareto Chart
1
categorization
1
max several rows
1
community
1
R
1
Subscription
1
Maximum number of values
1
gauges
1
to
1
CSV
1
Calendars
1
Cumulative sum partition
1
Stock In Hand
1
Transaction
1
numbertostring
1
Nonlinear Regression
1
Production
1
debit
1
F
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
Data Type
1
Year to date
1
Group By For Two Columns in Dax
1
Window Function
1
NewBusiness
1
volume concentration
1
Delimiters
1
perce
1
@inventory @DAX
1
change time format
1
revenue
1
actuals
1
static value
1
@Greg_Deckler @Mich_J @amitchandak
1
repurchase
1
Transliteration
1
by count
1
recruiting
1
@time
1
correlation
1
live dashboards
1
Map
1
key
1
target
1
transpose
1
counts
1
ALLCROSSFILTERED
1
Mean Time Between Failure
1
line chart visual
1
active customers
1
financial report
1
dataype
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
Average Sales
1
First Value
1
LostBusiness
1
concentration curve
1
Every
1
Variation
1
times
1
country
1
filtrar
1
capacity
1
isnonblank
1
hour
1
transform
1
by group
1
Duplicates
1
count of consecutive days
1
Custom Visual
1
s
1
Embed
1
Dynamic Column
1
Roles
1
timeline slicer
1
text filter
1
Power KPI Matrix
1
range
1
two tables
1
Match
1
date ranges
1
timeline report
1
multiple date tables
1
MoM
1
Null
1
Help with DATESYTD DAX
1
transitive closure
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
opening balance
1
ReturningBusiness
1
customer percentage vs sales percentage
1
Dynamic Ranking
1
ISNUMBER
1
WTD
1
display
1
relative date slicer
1
filtro de tiempo
1
completed
1
DAX table filter
1
new user
1
Rowtotal
1
QTR
1
Comparing columns
1
"LOOKUP" "DATA" "PERIOD" "INTERVAL" "BETWEEN" "SELECT" "FILTER" "TABLE"
1
Design
1
Azure
1
python
1
metric
1
loop up values from 2 tables
1
tutorial request
1
last date time refresh
1
spend
1
Power BI report builder
1
Tableau
1
Lookupvalues
1
selected value
1
Running Totals
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
su
1
daily difference
1
category
1
multiple join
1
fiscal
1
Dynamic Index
1
a da
1
Average x month-13
1
Rolling inventory in each month associated with SKU
1
@countifs functionality @Need Helop
1
Maxdate
1
Previous
1
of 108
Next