skip to main content
Power BI
Overview
What is Power BI
Why Power BI
Customer stories
Data visuals
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
Partners
Overview
Find consulting services
Partner showcase
Find a partner
Become a partner
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: Previous Week comparison
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
Previous Week comparison
.
Show all topics
How to get Previous Custom Week end date
by
auswtz
on
11-04-2020
11:05 PM
Latest post on
11-05-2020
04:58 PM
by
auswtz
2
Replies
116
Views
2
Replies
116
Views
Helpful resources
Top Labels
Alphabetical
DAX
837
Need Help
425
DAX Calculation
171
Measures
109
Filter
90
help
74
measure
72
Dax Help
60
CALCULATE
60
Power BI
50
Need Help DAX
46
DAX Query
43
COUNT
39
Help Requested
37
DAX filter formula
37
Date
36
Help me please
35
RANKX
34
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
average
23
SUMMARIZE
23
Calculated columns
22
DAX Commands and Tips
22
dax measure
22
if statement
21
Show and Tell
20
DAX Commands
19
Help me
19
dates
19
TopN
19
Filtering
18
Slicer
18
if
17
Help with DAX Measure
15
Conditional Formatting
15
Filters
15
Date and Time
14
help needed
14
Matrix Visual
14
Formula
14
DATEDIFF
13
dax functions
13
Power Query
13
percentage
13
DAX. CALCULATE
13
PowerBI Desktop
13
Calculatetable
12
running total
12
all
12
Distinct
12
LOOKUPVALUE
12
DATEADD
12
ranking
11
RLS
11
distinctcount
11
ALLEXCEPT
11
DAX function
11
help in dax Function
11
calculated column
11
Get Help
11
Month
10
YTD
10
ALLSELECTED
10
sumx
10
values
10
matrix
10
Max
10
Switch()
10
Power BI Dax
9
divide
9
Measure Column Total
9
hierarchy
9
rank
9
Distinct Counts
9
Filter context
9
Desktop
9
time functions
9
Year
8
SELECTEDVALUE
8
VAR
8
Cumulative Sum
8
@NeedHelp
8
Date measures to filter data.
8
DAX For Filter
8
powerbi
8
COUNTROWS
8
averagex
8
Compare
8
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
DAX Direct Query
7
columns
7
USERELATIONSHIP
7
MAXX
7
Cumulative Totals
6
CountIfs
6
Data Modeling
6
Table Visual
6
min
6
index
6
average of a measure
6
time
6
Urgent Help
6
SUMIF
6
Top N
6
cumulative
6
General
6
TOTALYTD
6
value
6
context
5
DAX BUG
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
DAX RANKX
5
total
5
CONTAINS
5
calculated table
5
slicers
5
rolling 12
5
today
5
QTD
5
Virtual Table
5
subtract filtered value
5
column
5
optimize
4
PowerBI Community
4
blank
4
DAX Filtering
4
Totals
4
crossfilter
4
rows
4
MTD
4
Sumx()
4
KPI
4
COUNTX
4
Direct Query
4
CONCATENATEX
4
tabular
4
Formatting
4
card
4
EARLIER
4
@Please Help
4
SSAS
4
chart
4
subtotals
4
Many to Many Relatioinship
4
conditional
4
rolling
4
lookup
4
Need Info
4
sumifs
4
Average Grand Total
4
dynamic table
4
Measures to filter out
4
group
4
SQL to DAX
4
Matrix Visualisation
4
Dax studio
4
VLOOKUP
4
Need Help - Goals
4
isfiltered
4
DAX ALL PowerBI Excel
4
Calculations
4
Tip & Tricks
4
Visual
4
Power BI Desktop
3
Visual Filtering
3
POWER BI DATA VİEW
3
condition
3
SUMMARIZECOLUMNS
3
Cumulative Totals by category
3
variable
3
dax tip
3
Filter based on context
3
Variable calculation
3
tutorials
3
averages
3
selected values
3
date interval
3
Line chart
3
Weekday
3
Format
3
change
3
rolling dates
3
calculation groups
3
Group By
3
Interesting Links
3
Visualization
3
relatedtable
3
Search
3
Pareto Chart and table by Period help
3
range of text
3
cumulative value
3
context filter
3
DAX SWITCH
3
Text
3
date slicer
3
forecast
3
Year over Year
3
Performance
3
SUM of Units
3
Performance Issues
3
hasonevalue
3
weighted averages
3
keepfilters
3
CUMULATIVE COUNT
3
calculated rows
3
MAX date
3
INACTIVE RELATIONSHIP
3
percentages
3
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
datesinperiod
3
PBI Desktop
3
SAME PERIOD LAST YEAR
3
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
FILTERS DAX KEEPFILTERS
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
30
2
Circular dependency
2
@Dax
2
Excel
2
Forecasting
2
ID
2
line graph
2
M
2
bar charts
2
cumulative sum by category
2
Advanced filtering
2
New Challenge
2
New Help
2
unique
2
date range
2
SVG
2
PowerBI Help
2
General Question
2
grand total row incorrect
2
Calculatetable filter
2
Help appreciated
2
employee
2
Events in progress
2
addcolumn
2
holidays
2
subtotal
2
DAX Language
2
calendar
2
percentile
2
Multiplying by Sum
2
previous year
2
Total wrong in matrix
2
Categories
2
unpivot
2
i
2
bar chart
2
Conversion
2
Previous month
2
Variances
2
drill
2
custom formula
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
union
2
General Comment
2
column total
2
Median
2
Field Value
2
Managing Roles
2
Total Sum
2
Ignore Slicers
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
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
grouped
2
dates table
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
REMOVEFILTERS
2
sorting
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
Search table columns for similair data
2
Direct Query mode
2
multiple tables
2
Dynamic data selection based on date
2
WEEKNUM
2
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
bad data
1
DAX com
1
Circle diagram
1
Line & Stacked Column
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
Need to mark holidays in calendar
1
fill empy cell
1
INCORRECT CALENDAR
1
Tutorial
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
Match calculated ranking column
1
variance
1
Error due to relationship
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
"average"
1
Dynamic Flag
1
XLOOKUP
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
incorrect total
1
salary
1
ArcGIS Map
1
Work days
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
CD and CSD
1
Dimension
1
result
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
&&
1
new measure of % by group
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
add value from prior row measure
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
simple
1
Please save me
1
previousmonth
1
EARLIEST
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
title
1
I'm losing my mind
1
Multiplication and wrong total in table
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
dataype
1
in chosen periods
1
Custom calendar
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
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
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
selected value
1
Running Totals
1
Bundle
1
DAX for deals added and slipped
1
veryon
1
aaa
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
DATESYTD Help needed
1
ONE TABLE MODEL
1
select all
1
COVID-19
1
Text Measure
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
Replace Text Based on Another Column
1
like to get
1
fortnight
1
TopN by Store
1
Rolling 12 Months
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
Group total
1
Previous
1
of 100
Next