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: Tip
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
Tip
.
Show all topics
Sharing: How to create test data using DAX!
by
stevedep
on
02-24-2021
06:09 AM
0
Replies
203
Views
0
Replies
203
Views
Helpful resources
Top Labels
Alphabetical
DAX
1,029
Need Help
511
DAX Calculation
203
Measures
130
Filter
100
help
85
measure
77
Need Help DAX
75
CALCULATE
72
Dax Help
63
Power BI
59
Help Requested
51
Need Help DAX measure
49
Date
45
DAX Query
45
COUNT
45
Help me please
41
RANKX
39
DAX filter formula
38
Tips and Tricks
37
Time Intelligence
34
Help required
34
POWER BI Dax rules
32
DAX Commands and Tips
32
Help with DAX
31
Table
30
DAX Commands
29
Calculated columns
29
SUMMARIZE
28
sum
28
average
27
Help me
25
Slicer
23
dax measure
22
Show and Tell
21
if statement
21
TopN
20
Filtering
20
dates
20
Filters
19
if
19
Help with DAX Measure
18
Matrix Visual
18
Conditional Formatting
17
Power Query
17
Formula
17
DATEDIFF
17
Date and Time
17
PowerBI Desktop
15
LOOKUPVALUE
15
running total
15
Desktop
14
percentage
14
Power BI Dax
14
Distinct
14
dax functions
14
YTD
14
help needed
14
DATEADD
14
distinctcount
14
sumx
13
divide
13
DAX. CALCULATE
13
calculated column
13
Get Help
13
ranking
13
powerbi
13
Max
12
all
12
hierarchy
12
ALLSELECTED
12
RLS
12
values
12
matrix
12
DAX function
12
Calculatetable
12
SELECTEDVALUE
12
ALLEXCEPT
12
DAX Measures
12
help in dax Function
11
DAX For Filter
11
Switch()
11
Distinct Counts
11
switch
10
Month
10
if condition
10
Filter context
10
Measure Column Total
10
Related Tables
9
Date measures to filter data.
9
VAR
9
@NeedHelp
9
datesbetween
9
averagex
9
time functions
9
Compare
9
DAX Filtering
9
Dax commands help
9
COUNTROWS
9
groupby
9
tables
9
rank
9
Dynamic Date Period
9
DAX ALL PowerBI Excel
8
USERELATIONSHIP
8
average of a measure
8
DAX Time Intelligence
8
Year
8
columns
8
Tutorial Requests
8
MAXX
8
column calculation
8
Difference
8
Cumulative Sum
8
EARLIER
7
variables
7
General
7
crossjoin
7
slicers
7
Aggregation
7
cumulative
7
Matrix Visualisation
7
value
7
Interesting Links
7
DAX Direct Query
7
Power Pivot
7
time
7
Data Modeling
7
column
7
measure based on slicer
7
KPI
7
needhelp
7
Tip & Tricks
6
Urgent Help
6
Need Help - Goals
6
SUMIF
6
blank
6
Cumulative Totals
6
TOTALYTD
6
Calculations
6
total
6
Virtual Table
6
calculation groups
6
currency conversion
6
@Please Help
6
index
6
join
6
CountIfs
6
Help appreciated
6
Table Visual
6
min
6
Top N
6
All()
6
AND
5
subtract filtered value
5
today
5
SQL
5
DAX RANKX
5
context
5
pareto
5
SUMMARIZECOLUMNS
5
datesinperiod
5
MAX date
5
Many to Many Relatioinship
5
dax formula
5
QTD
5
card
5
calculated table
5
rolling 12
5
Visual
5
POWER BI DATA VİEW
5
Direct Query
5
Totals
5
Group By
5
@Dax
5
Need Info
5
percentages
5
MTD
5
change
5
CONTAINS
5
SAME PERIOD LAST YEAR
5
Tips
5
Urgent Help with DAX
5
DAX BUG
5
SSAS
4
tabular
4
conditional
4
COUNTX
4
dax tip
4
cumulative value
4
Dynamic
4
Average Grand Total
4
Search
4
Slicer Visualizations
4
SQL to DAX
4
Switch Metric
4
DAX Data Table
4
Power BI Desktop
4
Format
4
subtotals
4
optimize
4
group
4
chart
4
Formatting
4
minx
4
dynamic table
4
Date Table
4
keepfilters
4
Performance
4
averages
4
@dax @help
4
weekly-averages
4
column selection
4
budget
4
Summary
4
Filter Multiple Column
4
crossfilter
4
rows
4
VLOOKUP
4
CONCATENATEX
4
Variable calculation
4
forecast
4
PowerBI Community
4
REMOVEFILTERS
4
isfiltered
4
variable
4
sumifs
4
Text
4
dates table
4
Measures to filter out
4
grouping
4
rolling
4
lookup
4
date slicer
4
Sumx()
4
Dax studio
4
Year over Year
4
LASTNONBLANK
4
Report
3
PBI Desktop
3
SUM of Units
3
Performance Issues
3
previous year
3
relatedtable
3
WEEKNUM
3
function
3
Optimizing DAX
3
date calculation
3
calculated rows
3
Variances
3
FILTERS DAX KEEPFILTERS
3
COUNTIF
3
metrics
3
dax mode count
3
Field Value
3
Data Modelling
3
bar charts
3
Filter based on context
3
Rankx with filter
3
Row Level Security
3
tutorials
3
Waterfall Chart
3
Merge
3
context filter
3
Cumulative Totals by category
3
Last date
3
Excel
3
query
3
color
3
Dax Join
3
subtotal
3
PowerBI Help
3
Circular dependency
3
what if parameters
3
running balance
3
hasonevalue
3
weighted averages
3
snapshot
3
Visualization
3
Calc column assistance
3
firstdate
3
Need help (Using direct query)
3
DAX SWITCH
3
rolling dates
3
Weekday
3
General Question
3
Need Help re Measure Formatting
3
M Query
3
bar chart
3
Last Year
3
INACTIVE RELATIONSHIP
3
SLA
3
Line chart
3
condition
3
IF ELSE
3
Pareto Chart and table by Period help
3
Need Assistance
3
Loop
3
multiple rows
3
Data Protection
3
Running Totals
3
Standard Deviation
3
calendar
3
selected values
3
range of text
3
@need help
3
Visual Filtering
3
CUMULATIVE COUNT
3
Calander
3
distribution
3
Slicer based on calculated Measure
3
SSAS Tabular
3
ID
3
date interval
3
Dashboard
3
Conversion
3
line graph
3
Unique Value
3
multiple column
3
union
3
M
3
related
3
Tips & Tricks
2
timeline
2
benchmark
2
Total wrong in matrix
2
Categories
2
Dynamic data selection based on date
2
custom column
2
COUNTA
2
Quarter over Quarter
2
combine
2
FIFO
2
variance
2
sales
2
day
2
DAX tips
2
guidelines
2
Query Editor
2
Reporting
2
Visualisations
2
Regression
2
Median
2
Managing Roles
2
Analysis
2
Stock Valuation
2
SVG
2
help with date
2
Calculate function with multiple criteria
2
Calculated Measures Only
2
DAX Max Date within date range
2
expression
2
Groups
2
calculation
2
Count rows (date) by month
2
Age
2
previous
2
Retention
2
"aggregations"
2
30
2
Userrelationship
2
Iterator
2
weighted
2
Moving average
2
partial
2
BINS
2
New Help
2
segmentation
2
exclude
2
concatenate
2
relations
2
holidays
2
Month on Month Rank Comparison
2
blanks
2
measures in calculated columns
2
LastDate
2
previous week
2
Security roles
2
beginner
2
Composite Model
2
drill
2
cumulative sum by category
2
sort formula
2
@Dax Measure Error
2
Countdistinct
2
recursive
2
Analysis Service
2
Azure Analysis services tabular model
2
selection
2
while
2
negative
2
aggregate
2
Advanced filtering
2
Groupings
2
cummulative dax
2
CALENDAR()
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
unpivot
2
grand total row incorrect
2
cohort
2
syntax
2
New Challenge
2
Forecasting
2
yoy
2
percentile
2
Power BI Help
2
tutorial request
2
NOT
2
Visuals
2
e
2
complex
2
searching from 2 tables
2
Need Hepl
2
M language
2
Total Sum
2
Custom Filter
2
Last
2
DAX Language
2
drillthrough
2
cumulative percentage
2
OR function
2
relationships
2
Calculatetable filter
2
dynamic filter
2
date format
2
unique
2
DAX for max utilisation
2
%
2
sumtotal
2
Ignore Slicers
2
Week time intelligence
2
DAX Hierarchy
2
pivot table
2
fiscal
2
Row
2
DAX Syntax
2
categorization
2
update
2
analysis services
2
mdx
2
calculated tables
2
employee
2
In
2
grand total
2
tricks and tips
2
Rolling Months
2
Search table columns for similair data
2
Direct Query mode
2
grouped
2
commands
2
SUM based on existing context created by a measure
2
General Comment
2
i
2
Please help
2
Multiplying by Sum
2
Summerizecolumn
2
New Table creation
2
cummulative
2
available
2
row context
2
Duplicate data
2
column total
2
duration
2
Previous month
2
date range
2
multiple tables
2
sorting
2
SUM of MAX
2
Moving average for measures
2
date filter
2
segment
2
How To
2
Power
2
Desktop version
2
Events in progress
2
addcolumn
2
date hierarchy
2
Workday
2
conditional column
2
Concatenate columns in a measure
2
Embed
1
Dynamic Column
1
date slicers
1
Memory
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
741 ADM 14
1
annual
1
hI i
1
Path
1
countblank
1
Bin
1
Conditional Formation Icons
1
14 day
1
Overlap
1
newbie
1
predictive models
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
Management
1
Azure
1
Roles
1
key
1
Scheduling
1
relative date filtering
1
default
1
Format Date
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
507 AE 990 AEDU 201 AEM 4
1
conditional replace
1
Parent
1
running
1
optimised
1
Non Calendar FY and FQ
1
Previous Week comparison
1
sum vs target
1
working days
1
Case statement
1
NBA
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
Security
1
Maximum number of values
1
Scorecard
1
Urgent
1
refresh 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
coalesce
1
Selections
1
resource utilzation
1
growth rate
1
basket analysis
1
outbound delivery
1
395 AEMD 2
1
Weekly YOY
1
Combination Table
1
Child
1
hide
1
HASONEFILTER
1
SEQUENCE
1
Unique Measure.
1
Button
1
multiple filters
1
Subtract
1
cardinality
1
Basket
1
Runnig Total
1
dynamic field
1
DATESMTD()
1
DATATABLE
1
cumulative distinct count
1
Questions
1
TopN Customer
1
error
1
target
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
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
POPL
1
DAX formula for tracking daily death cases
1
Merge files
1
sort
1
Help to Create Dax: applying filter for both Data Type(Text and Date)
1
TOTALMTD
1
record
1
Time Range
1
unix
1
Time interval
1
summarize table
1
Power BI Service
1
Financial
1
gauges
1
to
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
multiple dates
1
bell curve
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
List value account
1
Running Total Weekly
1
time-intelligence
1
DAV
1
related table
1
Load Time
1
order time
1
sum duplicate dates
1
Load Graphs
1
Model
1
Google Analytics
1
Issue
1
data refresh
1
transpose
1
counts
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
available time
1
List sorting
1
overlaying graph
1
Combine Values
1
Tag rows
1
time format
1
Current Year VS Last Year
1
Networkdays
1
simulation
1
Parameter Data Type
1
month-to-date
1
Cumulative Total
1
STARTOFMONTH
1
attrition
1
Disconnected tables
1
Resource Use
1
finance
1
queries
1
Dynamic RLS
1
Live Connection
1
timeline slicer
1
text filter
1
Power KPI Matrix
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
conditional columns
1
resets if 0
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
12 hour
1
Start and end period
1
true ()
1
i need help
1
invoice
1
Navigation
1
Trend Line
1
NoData
1
Days
1
iteration
1
DAX Relationships
1
Rate of Production
1
Salesforce
1
Pricing
1
parameter
1
Query String
1
Python
1
range
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
Data Type
1
Year to date
1
Row Number in DAX
1
90
1
work load
1
customer concentration
1
conditonal formatting
1
rowlevelsecurity
1
@stock_managment
1
one slicer to filter another table
1
24 hour
1
visual filter
1
Minimum AVG
1
isinscope
1
Intersect
1
ADDCOLUMNS()
1
Last N Months Data
1
KEEP
1
Tip
1
Months between
1
PowerQuery
1
survey
1
Scheduled data refresh
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
Average Sales
1
Group By For Two Columns in Dax
1
Window Function
1
NewBusiness
1
volume concentration
1
Delimiters
1
perce
1
@inventory @DAX
1
relationship
1
change format
1
filter by date hierarchy
1
@get help
1
SCD2
1
Quarter Issue
1
busqueda rangos
1
Meausre
1
Sample
1
contract
1
TREATAS
1
Education
1
BUG
1
Embed Report
1
weekly
1
What If
1
multiple
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
First Value
1
LostBusiness
1
concentration curve
1
Every
1
Variation
1
change time format
1
revenue
1
DATEADD Visit Windows
1
slicer calculation
1
Average from Matrix
1
rangos
1
first per day
1
Advanced
1
interaction
1
dax problem
1
Dinamyc index
1
community
1
Premium
1
DirectQuery
1
Fiscal Year
1
automation
1
scheduled
1
running-totals
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
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
ReturningBusiness
1
customer percentage vs sales percentage
1
Dynamic Ranking
1
ISNUMBER
1
WTD
1
times
1
country
1
actuals
1
exponent
1
ratio calculations dax
1
weeks
1
help measure
1
Conteo
1
maxium
1
dax calculations
1
DAX help needed
1
page filters
1
append
1
quetsion
1
node
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
category
1
multiple join
1
Dynamic Index
1
a da
1
Average x month-13
1
display
1
filtrar
1
static value
1
@Greg_Deckler @Mich_J @amitchandak
1
repurchase
1
unico
1
Pareto Chart
1
max several rows
1
DatesMTD
1
Future Dates
1
Custom Visual
1
R
1
data
1
Active Directory
1
Gantt chart
1
tooltips
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
Except
1
Rebasing
1
Row Average
1
Column Chart
1
remote computers
1
Financial Year
1
able
1
Day on Day
1
Realtotals
1
new calculated table
1
consolidation
1
Report view
1
conditional format
1
Rolling inventory in each month associated with SKU
1
@countifs functionality @Need Helop
1
Maxdate
1
relative date slicer
1
capacity
1
isnonblank
1
hour
1
Transliteration
1
by count
1
recruiting
1
@time
1
Fact
1
apply
1
l
1
correlation
1
Gantt
1
Dynamics 365
1
stacked bar
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
compound
1
new calculated column
1
YoY Line Charts
1
font colour
1
scalar
1
verting H
1
many to many
1
org chart
1
firstnonblank
1
filtro de tiempo
1
completed
1
DAX table filter
1
new user
1
transform
1
by group
1
Duplicates
1
count of consecutive days
1
@related @tables @relations
1
FPY
1
Data model
1
s
1
live dashboards
1
themes
1
drill through
1
Streaming Datasets
1
need
1
formating
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
Substract with a measure
1
return
1
scenario
1
show statusRDP
1
@Ranks with Trend
1
color palette
1
returns
1
hex
1
if and else
1
with filters
1
filter context intersection
1
Table cell background color
1
"beginner asks Help"
1
Inventory
1
quota
1
Alias on summ
1
dax calculated
1
Rowtotal
1
QTR
1
Comparing columns
1
"LOOKUP" "DATA" "PERIOD" "INTERVAL" "BETWEEN" "SELECT" "FILTER" "TABLE"
1
FirstPass
1
Design
1
SharePoint
1
Map
1
Subscription
1
evaluation
1
Data Source
1
numbers
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
Match calculated ranking column
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
mailto
1
PRICE_NAME SUM(CALLS_SUM) AD 12
1
replace
1
DAX formulas for total quantity matching
1
Monthly percentages
1
EarlierFunction
1
background color
1
New quick measure
1
Customer Revenue Comparison
1
Overlapping tables
1
math
1
Mongodb
1
VAT
1
comapring
1
Power M Query
1
webpagelinking
1
not null
1
Previous
1
of 114
Next