DAX Commands and Tips

Skip to main content

Fabric Community

Power BI

Synapse

Data Factory

Real-Time Intelligence

Power BI

Synapse

Data Factory

Real-Time Intelligence

Fabric PowerPoint Presentations

Community News

Ideas

User Groups

Updates Blog

Career Hub

Cloud Skills Challenge

Career & Learning Discussion

Learn Modules

Tutorials

Documentation

Community blog

Events

Support

Azure Data Community

Register

Sign in

Help

Go To

Power BI forums
Updates
News & Announcements
Get Help with Power BI
Desktop
Service
Report Server
Power Query
Mobile Apps
Developer
DAX Commands and Tips
Custom Visuals Development Discussion
Health and Life Sciences
Power BI Spanish forums
Translated Spanish Desktop
Training and Consulting
Instructor Led Training
Dashboard in a Day for Women, by Women
Galleries
Community Connections & How-To Videos
COVID-19 Data Stories Gallery
Themes Gallery
Data Stories Gallery
R Script Showcase
Webinars and Video Gallery
Quick Measures Gallery
2021 MSBizAppsSummit Gallery
2020 MSBizAppsSummit Gallery
2019 MSBizAppsSummit Gallery
Events
Ideas
Custom Visuals Ideas
Issues
Issues
Events
Upcoming Events
Community Blog
Power BI Community Blog
Custom Visuals Community Blog
Power BI 中文博客
Community Support
Community Accounts & Registration
Using the Community
Community Feedback

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:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Power BI forums

Forums

Get Help with Power BI

DAX Commands and Tips

Topics with Label: Filter context

Join the discussion

Options

Mark all as New

Mark all as Read

Float this item to the top

Subscribe

Bookmark

Subscribe to RSS Feed

Previous

1
2

Next

Showing topics with label Filter context. Show all topics

Have calculations only work in the filtered contex...

by Kalibur on ‎03-05-2024 01:49 PM Latest post on ‎03-06-2024 05:34 AM by Kalibur

2 Replies 340 Views

2 Replies
340 Views

Filter context in dax with relationship clarify

by Petr__ on ‎02-27-2024 12:00 PM Latest post on ‎02-28-2024 05:39 PM by v-tangjie-msft

8 Replies 465 Views

8 Replies
465 Views

Can one slicer filter be selectively applied while...

by afaro on ‎02-08-2024 09:00 AM Latest post on ‎02-12-2024 09:54 AM by afaro

3 Replies 253 Views

3 Replies
253 Views

How to force DAX measure to 0 in the same filter c...

by fbura on ‎11-21-2023 02:55 AM Latest post on ‎11-23-2023 01:19 AM by v-rzhou-msft

2 Replies 251 Views

2 Replies
251 Views

Keeping and ignoring filtercontext over different ...

by OlafCdeWit on ‎11-17-2023 05:42 AM Latest post on ‎11-20-2023 04:00 AM by tamerj1

3 Replies 236 Views

3 Replies
236 Views

How does SELECTEDVALUE work?

by jaderickerts on ‎10-30-2023 04:38 AM Latest post on ‎10-31-2023 12:08 AM by scee07

2 Replies 222 Views

2 Replies
222 Views

Previous User Selected Value

by giammariam on ‎10-10-2023 05:20 PM Latest post on ‎10-10-2023 11:17 PM by ValtteriN

1 Reply 173 Views

1 Reply
173 Views

Optimized DAX code for calculating on different Fi...

by HamidRezaSajjad on ‎09-12-2023 01:25 AM Latest post on ‎09-18-2023 12:02 AM by HamidRezaSajjad

1 Reply 163 Views

1 Reply
163 Views

Need help with Filter Context Issue

by Anonymous on ‎08-28-2023 09:44 AM Latest post on ‎09-03-2023 01:48 PM by some_bih

1 Reply 194 Views

1 Reply
194 Views

Filter within calculate does not filter other visu...

by Anonymous on ‎07-25-2023 02:16 PM Latest post on ‎07-27-2023 12:48 AM by v-rzhou-msft

1 Reply 155 Views

1 Reply
155 Views

DAX measure to count active cases within date filt...

by AGuldbrandt on ‎07-14-2023 02:11 AM Latest post on ‎07-17-2023 02:43 AM by AGuldbrandt

2 Replies 359 Views

2 Replies
359 Views

Remove the Row context while keeping Filter contex...

by marcofalzone on ‎06-30-2023 08:02 AM Latest post on ‎07-07-2023 05:27 PM by marcofalzone

2 Replies 769 Views

2 Replies
769 Views

Compare two contexts to the same fact table

by soldous on ‎05-01-2023 02:26 PM Latest post on ‎05-02-2023 04:28 PM by lbendlin

1 Reply 321 Views

1 Reply
321 Views

SUM measure for multiple partitions

by Anonymous on ‎03-28-2023 07:34 AM Latest post on ‎03-31-2023 06:21 AM by AlexisOlson

5 Replies 741 Views

5 Replies
741 Views

DAX Fetch base value of 1 column and multiply it t...

by Anonymous on ‎09-06-2022 02:34 AM Latest post on ‎09-07-2022 10:05 PM by Anonymous

4 Replies 426 Views

4 Replies
426 Views

Filtering model on latest version of all attribute...

by ramiouaness on ‎07-19-2022 01:03 PM Latest post on ‎07-22-2022 12:33 AM by v-chenwuz-msft

1 Reply 213 Views

1 Reply
213 Views

Add row/filter context to SUMMARIZECOLUMNS measure

by RobinNeven on ‎06-08-2022 08:10 AM Latest post on ‎06-13-2022 03:53 AM by RobinNeven

6 Replies 939 Views

6 Replies
939 Views

Display totals for parent item(s) in hierarchy whe...

by tnwcloud on ‎05-08-2022 10:08 PM Latest post on ‎05-12-2022 12:51 AM by v-yangliu-msft

3 Replies 522 Views

3 Replies
522 Views

Simple CALCULATE measure is testing my fundamental...

by MarianoG on ‎03-31-2022 08:24 PM Latest post on ‎03-31-2022 08:56 PM by MarianoG

2 Replies 265 Views

2 Replies
265 Views

% share of revenue calculation filter issue

by woombers on ‎02-09-2022 08:32 AM Latest post on ‎02-10-2022 01:28 AM by tamerj1

9 Replies 709 Views

9 Replies
709 Views

Help with relativelly "simple" mesure that ignore ...

by erfaldo on ‎11-21-2021 01:33 PM Latest post on ‎11-22-2021 02:15 AM by erfaldo

2 Replies 415 Views

2 Replies
415 Views

Average without Filter context

by DAsilar on ‎11-06-2021 03:57 PM Latest post on ‎11-07-2021 02:16 AM by DAsilar

2 Replies 2977 Views

2 Replies
2977 Views

Ignoring slicers using mutlple filter expressions ...

by Wilm117 on ‎07-27-2021 06:00 AM Latest post on ‎07-27-2021 08:57 AM by Anonymous

1 Reply 205 Views

1 Reply
205 Views

Remove Row context without removing Filter Context

by imoreno on ‎06-13-2021 11:28 PM Latest post on ‎06-15-2021 12:45 AM by imoreno

4 Replies 8778 Views

4 Replies
8778 Views

DAX Filter Context Issue

by keobrie on ‎02-20-2021 12:29 PM Latest post on ‎02-22-2021 08:42 AM by keobrie

2 Replies 445 Views

2 Replies
445 Views

Calculating Average of Sum Measurement

by jcast on ‎01-14-2021 11:51 AM Latest post on ‎01-14-2021 01:27 PM by AlB

1 Reply 506 Views

1 Reply
506 Views

Filter context of table viz

by CNENFRNL on ‎11-08-2020 02:56 PM Latest post on ‎11-08-2020 05:54 PM by amitchandak

2 Replies 427 Views

2 Replies
427 Views

Dynamically show the latest value of Items in a se...

by Anonymous on ‎07-23-2020 03:29 AM Latest post on ‎08-04-2020 07:29 AM by sturlaws

2 Replies 1617 Views

2 Replies
1617 Views

Running Total unabled while clicking on specific m...

by Anonymous on ‎06-13-2020 05:56 PM Latest post on ‎06-15-2020 07:59 AM by Anonymous

5 Replies 1050 Views

5 Replies
1050 Views

Filter context issue trying to visualize top ranke...

by arielcedola on ‎06-01-2020 08:33 AM Latest post on ‎06-03-2020 04:37 AM by stevedep

4 Replies 738 Views

4 Replies
738 Views

Previous

1
2

Next

Helpful resources

Top Labels

Alphabetical

DAX 3,782

Need Help 2,902

"DAX" 507

help 414

DAX Calculation 413

Need Help DAX 323

Filter 317

"Need Help" 312

Measures 289

"DAX help" 278

measure 267

Tips and Tricks 248

Help Requested 237

CALCULATE 225

Power BI 220

Show and Tell 215

Need Help DAX measure 190

DAX Commands and Tips 169

COUNT 148

Help appreciated 148

Help me please 147

Date 143

Help me 132

Slicer 130

Dax Help 128

@Dax 127

@Dax help 120

DAX Measures 111

RANKX 109

Tutorial Requests 108

SUMMARIZE 106

Help with DAX 105

DAX Commands 103

Help required 100

Help Request 95

Time Intelligence 86

sum 85

powerbi 85

average 83

"Help" 82

Table 77

@dax @help 76

Power Query 74

@Daxhelp 74

dates 71

@NeedHelp 71

DAX Query 69

DAX help needed 69

matrix 68

Calculated columns 68

if 67

POWER BI Dax rules 67

DATEDIFF 66

"DAX " 61

sumx 60

LOOKUPVALUE 59

COUNTROWS 59

Filters 55

"MEASURE" 54

Formula 53

Conditional Formatting 52

TopN 51

"Calculated Column" 50

calculated column 50

Help with DAX Measure 49

"CALCULATE" 49

Matrix Visual 47

help needed 46

Desktop 45

Max 44

General Comment 44

"Power BI" 42

Need Assistance 42

DAX filter formula 42

SELECTEDVALUE 41

dax measure 40

"FILTER" 39

Power BI Dax 38

DAX Formulas 38

RLS 37

"DAX Commands and Tips" 36

ALLSELECTED 36

Get Help 36

running total 36

Power BI Desktop 36

distinctcount 36

MAXX 35

all 35

percentage 35

Filtering 35

Distinct Counts 34

Filter context 34

if statement 34

YTD 34

@Power BI 33

divide 33

ALLEXCEPT 33

DATEADD 33

PowerBI Desktop 32

switch 32

rank 32

ranking 31

DAX Filtering 31

@Dax Measure Error 31

groupby 31

values 30

DAX ALL PowerBI Excel 30

@Please Help 30

Running Totals 30

Group By 30

Switch() 29

slicers 29

DAX Power BI 29

Distinct 29

"beginner asks Help" 29

"dax code" 28

Data Modeling 28

Hierarchy 28

dax formula 28

USERELATIONSHIP 28

'Need help' 'DAX' 28

@help 28

Urgent Help with DAX 27

column 27

Cumulative Sum 27

DAX Command 26

needhelp 26

EARLIER 26

Excel 25

Virtual Table 25

Measure Column Total 25

datesbetween 25

DAX FILTER 25

All() 25

total 25

Aggregation 25

Tips & Tricks 24

tables 24

SUMMARIZECOLUMNS 24

Dynamic 24

Calculatetable 24

Visual 24

"DAX help" DAX 24

Compare 23

Power Pivot 23

Calculated Measures 22

blank 22

Totals 22

DAX tips 22

REMOVEFILTERS 22

calculated table 22

variables 21

@measure 21

" Slicer" 21

Date and Time 21

CONCATENATEX 21

Interesting Links 21

Cumulative Total 21

DAX RANKX 21

Data Protection 21

error 20

VAR 20

time 19

@need help 19

Month 19

relationships 19

DAX. CALCULATE 19

Format 19

calculation 19

lookup 18

@Conditional Formatting 18

averagex 18

calculation groups 18

Urgent Help 18

MTD 18

Forecasting 18

related 17

if condition 17

cumulative 17

Need Dax 17

SQL 17

Need Help -DAX Measures 17

min 17

average of a measure 17

"DAX " "DAX help" 'Need help' 'DAX' 17

calendar 17

Dax commands help 17

DAX Time Intelligence 17

CONTAINS 16

Formula Help 16

MAX date 16

dax functions 16

Top N 16

Sameperiodlastyear 16

PowerBI Community 16

Circular dependency 16

Line chart 16

chart 16

"Time Intelligence" 16

card 16

Dax studio 16

Date Table 16

"RANKX" 16

"DAX" "Earliest date" 15

@powerbi 15

conditional 15

Table Visual 15

columns 15

KPI 15

Calculations 15

Need Urgent Help 15

Cumulative Calculation 15

duration 15

Need help (Using direct query) 15

DAX SUMMARIZE 15

COUNTX 15

Field parameters 15

index 15

value 15

If statements 15

Need Help in Power Bi 15

forecast 14

DAX For Filter 14

crossfilter 14

SAME PERIOD LAST YEAR 14

DAX function 14

POWER BI DATA VİEW 14

Matrix Visualisation 14

Running totals and cumulatives 14

context 14

Tips 14

DAX Averages 14

"CALCULATETABLE" 14

Direct Query 14

Slicer Visualizations 14

Related Tables 14

DAX Direct Query 14

DAX SWITCH 14

help in dax Function 14

relationship 13

Date measures to filter data. 13

Performance 13

DAX BUG 13

PowerQuery 13

Need help with DAX 13

Need DAX Help 13

"Dates" 13

concatenate 13

Optimizing DAX 13

LASTNONBLANK 13

sort 13

@measure filter 13

Difference 13

AND 13

CUMULATIVE COUNT 13

variable 13

Tutorial 13

"Date Table" 13

Urgent 13

"average" 12

WEEKNUM 12

Tip & Tricks 12

Rankx with filter 12

Dashboards 12

Matrix table 12

Sumx() 12

Duplicates 12

Text 12

question 12

Cumulative Totals 12

TOTALYTD 12

rows 12

weighted average 12

column calculation 12

condition 12

date slicer 11

function 11

DAX&Power Query 11

Variable calculation 11

RANKX issue 11

Filter Table 11

SUMIF 11

Measures to filter out 11

Commands and Tips 11

Calculation Group 11

needs help 11

VLOOKUP 11

blanks 11

Row Level Security 11

sorting 11

percentages 11

DAX Data Table 11

"Calculation Group" 11

Formatting 11

Visuals 11

minx 11

subtotal 11

DAX Date condition 11

Advance DAX 11

join 11

Slicer based on calculated Measure 11

sales 10

budget 10

currency conversion 10

Currency 10

Search 10

Moving average 10

General 10

pareto 10

Data Modelling 10

DAX Optimization 10

Year 10

time functions 10

CONTAINSSTRING 10

COUNTIF 10

@PowerBI Report 10

Median 10

datesinperiod 10

Last date 10

DAX SUMX 10

DAX Syntax 10

Hints & Tips 10

Please help 10

averages 10

Dynamic Ranking 10

Rolling 12 Months 10

query 9

PowerBI Help 9

DAX SUM 9

row context 9

'Need help' 9

new column 9

grand total 9

subtotals 9

group 9

dynamic table 9

date calculation 9

Dynamic Date Period 9

SSAS Tabular 9

grouping 9

@PowerQuery 9

Report 9

Tableau 9

DAX Hierarchy 9

@DateTime Functions 9

Switch Metric 9

Previous month 9

context transition 9

Nead Help 9

ADDCOLUMNS 9

parameter 9

Performance Issues 9

Loop 9

keepfilters 9

Power BI Help 9

IF Functions 9

category 9

SUM based on some filter 9

bar chart 9

CountIfs 9

Weekday 9

Parent child 9

PowerBI DAX 9

How To 9

M 9

isfiltered 9

measure based on slicer 9

Calculate function with multiple criteria 8

Conditional Formula 8

what if parameters 8

Clustered Column Chart 8

crossjoin 8

Reports 8

Year over Year 8

COUNTA 8

.DAX 8

previous year 8

"Show and tell" 8

"Power Query" 8

legend 8

target 8

Year to date 8

Average Grand Total 8

ORDER 8

TREATAS 8

@power bi desktop 8

Filter Multiple Column 8

QTD 8

Need Help - Goals 8

LastDate 8

Row 8

@get help 8

Countdistinct 8

formulas 8

"DAX create dynamic table from slicer date" 8

Standard Deviation 8

firstdate 8

INACTIVE RELATIONSHIP 8

Groupings 8

CALENDER 8

SSAS 8

FILTERS DAX KEEPFILTERS 8

OR 8

Dynamic RLS 8

SQL to DAX 8

Merge 8

MoM 8

Time interval 8

DirectQuery 7

M Query 7

Calculate dates 7

distinct count 7

multiple column 7

Inventory 7

syntax 7

segmentation 7

COLUMN VALUES 7

weekly 7

custom column 7

Multiple columns 7

exclude 7

Categories 7

Between dates 7

parameters 7

Many to Many Relatioinship 7

multiple tables 7

relatedtable 7

Advanced filtering 7

Iterator 7

DAX ALLSELECTED 7

tabular 7

unpivot 7

rolling sum 7

calculated tables 7

Filter Multiple Columns 7

@ Matrix Visualisation Error In Calculation 7

isinscope 7

IF AND with multiple conditions 7

Regression 7

Last Year 7

Tabular Model 7

powerpivot 7

Table Column 7

Offset 7

Data model 7

aggregate 7

DAX Language 7

Need Help re Measure Formatting 7

DATATABLE 7

logic 7

rolling 7

PBI 6

IF ELSE 6

CALENDAR() 6

Division 6

matrix calculation 6

optimize 6

Visual Filtering 6

duplicate 6

Conversion 6

comparison 6

Total not matching 6

union 6

ADDCOLUMNS() 6

dates between 6

RLS problems 6

isblank 6

DAX Total 6

previousmonth 6

conditional column 6

date filter 6

dax problem 6

'DAX' 6

color 6

Need Info 6

today 6

COUNTAX 6

rolling average 6

"DAX Query View" 6

Variances 6

variance 6

Data Type 6

Calculated Measures Only 6

Networkdays 6

string 6

@visual level filter 6

"Date" 6

graph 6

Waterfall Chart 6

ID 6

dates table 6

DAX Max Date within date range 6

Filter using a measure 6

"VAR" 6

"Power Pivot" 6

snapshot 6

selected value 6

dax tip 6

tooltip 6

Average from Matrix 6

"SELECTEDVALUE" 6

Duplicate data 6

dynamic filter 6

pivot 6

change 6

subtract filtered value 6

DAX TOPN 6

Visualization 6

Maxdate 6

Show & Tell 6

"DAX SWITCH" 6

SharePoint 6

Power 6

beginner 6

churn 6

Headcount 6

Percentage Difference 6

Calendar Table 6

percentile 6

previous 6

Summary 6

i need help 6

Month Calculation 6

" Error Handling" 6

Divide Function 6

In 6

Filter based on context 6

sumifs 6

Latest 6

cummulative 6

Intersect 6

data 6

PBI Desktop 6

column selection 6

recursive 6

@sumx 6

i 5

datesytd 5

graphs 5

new measure 5

calculate columns 5

Dax performance 5

DAX code 5

Help using powerbi 5

rolling 12 5

Unique Value 5

replace 5

Need help. 5

"TOPN" 5

mdx 5

running balance 5

context filter 5

Nee help 5

Questions 5

tricks and tips 5

CODE 5

Path 5

Chart Help 5

"Grand Total" 5

Measure Totals 5

"COUNT" 5

Need Hepl 5

New Table creation 5

DAX Performace 5

"help" "targets" "tables" "Related" 5

need helps 5

"Tips and Tricks" 5

line graph 5

SVG 5

MIN date 5

Dynamic row level security 5

measures in calculated columns 5

status 5

charts 5

tutorial request 5

maximum 5

"FORMULA" 5

date format 5

cumulative value 5

Total wrong 5

Dax Power Pivot 5

daxhelp 5

Custom Measures 5

commands 5

pivot table 5

Statistics 5

Duplicate Values 5

"SWITCH" 5

Modeling 5

Gantt chart 5

max date problem 5

Desktop version 5

profit and loss 5

Subtract 5

DAX TABLE 5

Average Rates 5

Pie Chart 5

" cumulatives" 5

Moving average for measures 5

Week 5

Custom Time Intelligence Function 5

Hierarchical slicer 5

"Data Model" 5

drill through 5

need 5

@inventory @DAX 5

Dynamic calculation 5

XIRR 5

Table variables 5

Conditional Sum 5

"MAX" 5

conditions 5

Week time intelligence 5

Working Hours 5

distribution 4

Dynamic Flag 4

Power Query Editor 4

SUM based on existing context created by a measure 4

Help to Create Dax: applying filter for both Data Type(Text and Date) 4

Tip 4

Gauge 4

Model 4

Live Connection 4

Composite Model 4

Total wrong in matrix 4

utilization 4

Custom Filter 4

stock 4

Conditional Formatting column 4

"subtotal 4

PREVIOUSDAY 4

@average 4

"Time" 4

Visualisations 4

yoy 4

range 4

Advanced Visualization 4

% 4

OR function 4

salary 4

Calculatetable filter 4

DAX Relationships 4

@ 4

monthlyaverage 4

DAX Filtering Slicer 4

Need help for Dax 4

finance 4

tutorials 4

multiple 4

selected values 4

hasonevalue 4

result 4

conditional columns 4

dax calculations 4

Dynamic filters 4

advanced dax 4

Customer 4

Dynamic Column 4

date range 4

Rolling Months 4

Histogram 4

summarize table 4

Tabular Editor 4

calculated 4

delta 4

DAX Divide Formula 4

What If 4

Security roles 4

WOW 4

Runnig Total 4

Sum & Totals 4

Functions 4

Conditional Totals 4

Hierarchy of matrix 4

update 4

previous week 4

Fiscal Year 4

rolling dates 4

many to many 4

stacked bar chart 4

count rows 4

dataset 4

Measure Multiplication 4

Cumulative Totals by category 4

Average Sales 4

multiple filters 4

Split column 4

Weekday calculation 4

cumulative total - running total 4

bridge table 4

@Show and Tell 4

@slicer 4

Dashboard 4

weighted 4

tickets 4

DATESYTD Help needed 4

cumulative sum by category 4

Need a help 4

Cohort Analysis 4

need Help with measure 4

P&L 4

dax variable 4

dimensions 4

multiple rows 4

opening balance 4

HASONEFILTER 4

working days 4

IF THEN ELSE 4

Custom Visual 4

metric 4

bar charts 4

First Value 4

SCD2 4

DATESMTD() 4

Average by other column 4

DAX ROW CONTEXT 4

Quarter 4

Product 4

status change 4

Direct Query mode 4

holidays 4

If Then 4

expression 4

AVG 4

Earlier Function 4

Query Editor 4

Dimension 4

growth rate 4

BINS 4

Date Calculation Error 4

New Table 4

Workday 4

fiscal 4

Rolling AVG 4

dynamic title 4

IF = BLANK() 4

GENERATESERIES 4

If function 4

Conditional measures 4

Calculate Sum 4

"Dynamic Slicer" 4

TopN Customer 4

SLA 4

metrics 4

weekly-averages 4

employee 4

Null 4

Dynamic Index 4

WTD 4

Quarter over Quarter 4

NOT 4

Total Measure 4

Dax_Help 4

YoY calculation 4

BUG 3

survey data 3

Dax Join 3

Visualizations 3

"aggregations" 3

basket analysis 3

new calculated column 3

New quick measure 3

Days 3

Summary Tables 3

Help me to find this DAX 3

Column Comparison 3

DAX Dynamic Top N 3

Running Balances 3

Power Query Tips & Tricks 3

Cost 3

to 3

New customers 3

Analysis 3

line chart visual 3

M language 3

circular 3

incorrect total 3

Backlog 3

monthly growth 3

Select 3

dynamic filtering 3

@tables 3

complex dax 3

@divide 3

API 3

Filter two tables 3

DAX CALENDARAUTO() 3

RankX excluding Some Values 3

Quarter Issue 3

aging 3

date averages 3

EOMONTH 3

Rolling Averages 3

Date filtering 3

Growth 3

recursion 3

DAX Filter table from slicer 3

"How To" 3

"Power Automate" 3

Calc column assistance 3

two tables 3

date interval 3

Column Chart 3

Calander 3

Start and end period 3

range of values 3

Role level security - multiple levels 3

ALL Function 3

@PowerBI Report. @dax 3

analysis services 3

e 3

Max date from select dates in Dataset 3

fortnight 3

General Question 3

Integer 3

Monthly percentages 3

visual filter 3

time-intelligence 3

optimization 3

Control Chart 3

DAX filters 3

Measure Total with VAR and IF statements 3

@Please Help HELP 3

dynamic data filtering 3

dax mode count 3

calculated rows 3

weighted averages 3

Apply Filter 3

Weekly YOY 3

day 3

Parent 3

sum vs target 3

Combine tables 3

datefilter 3

Percent 3

from 3

ROUND function 3

SUMMARIZE. SUMX 3

DAX FILTER ISSUES 3

accumulated measure 3

DAX SUMMARIZE FILTER GROUPBY 3

R script 3

guidelines 3

relative date filtering 3

column total 3

custom 3

FIFO 3

Help with DATESYTD DAX 3

Pareto Chart and table by Period help 3

sort formula 3

PARTITION 3

find 3

Conditionals 3

@Cummilative 3

tooltips 3

transpose 3

SUM of Units 3

unique 3

Power Automate 3

grand total row incorrect 3

EarlierFunction 3

weeks 3

LOD 3

virtual 3

Previous Row 3

time calculation 3

mapping 3

% CHANGE 3

Financial 3

text filter 3

Azure Analysis services tabular model 3

Absolute Value 3

active customers 3

PBIX Reports 3

column formatting 3

Difference Between Dates 3

0 3

DAX Date Table 3

Time Based Filter 3

List 3

Average of a result 3

Calculate function 3

Issue 3

Python 3

Calendars 3

start 3

Field Value 3

cumulative percentage 3

count distinct with condition 3

Ignore Slicers 3

help with date 3

Last 3

Flag 3

help measure 3

Trend Line 3

Need Suggestions 3

previous period 3

DAX Switch() 3

TimeIntelligence 3

HLP DAX formula 3

Average last 3 month 3

" cumulative " 3

How-to 3

BI Vs Tableau 3

Lookupvalues 3

empty columns 3

Userrelationship 3

DAX table filter 3

Previous row value 3

ratio 3

DAX Equation 3

Convert 3

%grand total 3

minimum 3

Combining two Rank measures by category 3

normalize 3

Dynamic data selection based on date 3

facts filtering dimensions 3

Control charts 3

Customers 3

hour 3

Fiscal Calendar 3

Slow Performance 3

Virtual Tables 3

Flow 3

Add Column 3

benchmark 3

complex 3

relations 3

Text Measure 3

Analysis in Excel 3

range of text 3

Substring 3

Accounting 3

new user 3

related table 3

Time Range 3

Average Averages 3

KPI Ranking 3

@ links to members 3

'Cumulative totals' 3

"Calculated Columns" 3

Retention 3

XLOOKUP 3

Except 3

DAX Division with Date 3

Intersection 3

Nested IF 3

DAX. 3

visual level filter 3

lost customer 3

"category" 3

drillthrough 3

General Comments 3

slow 3

negative 3

Counter 3

DAX for max utilisation 3

financial report 3

Find multiple values 3

HR 3

firstnonblank 3

attrition 3

DAX Measur 3

Burndown 3

CURRENTGROUP 3

field parameter 3

Earliest Date 3

support 3

Count rows (date) by month 3

SUM of MAX 3

Day of Week 3

Date DIFF 3

Lookup value 3

Date Function 3

Help! 3

Inventory Planning 3

need help in DAX 2

filtered values 2

filter propagation 2

Dax power query 2

Column Formula Assistance 2

Request 2

loading 2

link 2

Icons 2

Events in progress 2

percentiles 2

Summerizecolumn 2

fiscal period 2

YoY Line Charts 2

Report view 2

Rowtotal 2

iteration 2

evaluation context 2

Drilldown help 2

Point in time 2

Timestamp 2

Explicit measure 2

latitude 2

frequency 2

bar graph 2

% share 2

x-axis 2

subset 2

progress 2

DAX Cumulative Filter 2

"Time Zone" 2

blank values 2

fact table 2

Max Values 2

Content 2

Quick Tips 2

database 2

outliers-detection 2

selection 2

Sum on a dynamic date range 2

Data Analysis 2

new measure of % by group 2

returns 2

font colour 2

conditional format 2

Conditional Formation Icons 2

ratio calculations dax 2

Running Total Weekly 2

Pareto Chart 2

Months between 2

DynamicMeasure 2

medianx 2

hourly calendar 2

Mesasure 2

modelling 2

"Power BI Report Server" 2

left join 2

Remove Filters 2

"parameter" 2

"M Query" 2

Custom Visuals 2

axis 2

Missing data 2

dropdown 2

Age 2

dependency 2

KPI Indicator 2

Past & Current Month Latest data 2

Decomposition Tree 2

contract 2

sum of measure 2

match value 2

power-BI 2

Prior year filtering 2

empty cells 2

cumul 2

Filtered table 2

DAX tables 2

"Time Conversion" 2

RELATED() 2

@ excel table 2

DAX AVERAGE 2

Measure Help 2

Map 2

Paginated Report 2

BI 2

Streaming Datasets 2

Latest Date 2

sumtotal 2

grouped 2

Custom calendar 2

30 2

coalesce 2

Selections 2

date hierarchy 2

Productivity 2

stacked column chart 2

Month on Month Rank Comparison 2

display 2

Add "IF" before calculate 2

capacity 2

TOTALMTD 2

Custom Formatting 2

help with matrix 2

current month 2

Multiplier 2

Penetration 2

select date 2

Gross Profit % 2

Excel formula 2

FILL DOWN IN DAX 2

Historical Data 2

equals 2

Prior Year 2

Location 2

measure column 2

aggregated 2

above 2

DistinctCountX 2

shifts 2

ALL page filters 2

"CHART" 2

targets 2

New Help 2

Filter Changes 2

weekdays 2

custom formula 2

Substract with a measure 2

categorization 2

ageing AP & AR 2

runningtotal 2

Date Issues DateTime 2

percent change 2

dynamic lookupvalue 2

Trial Balance 2

Multiple Criteria 2

measure dynamic formatting 2

@FTE 2

DAX for Table filter from column in another table 2

compare row value. 2

gateway 2

date slicers 2

Power BI Data 2

gauges 2

filter pane 2

searching from 2 tables 2

addcolumn 2

return 2

Button 2

slicer calculation 2

month-to-date 2

dynamic segmentation 2

PARALLELPERIOD 2

ROWNUM 2

Guidance 2

Rollup 2

SELECTEDVALUE() 2

dynamic values 2

d 2

sum total 2

Need help! 2

same values 2

daX ERROR 2

"Multiplication" 2

Auto-exist 2

ProductX 2

"Tutorials" 2

Excel formula to Dax 2

Mysql 2

User 2

t 2

Visual Studio 2

many to many relationship issue 2

Multiplying by Sum 2

TOTALYTD through Today 2

Cumulative sum partition 2

calculate Percentile 2

EARLIEST 2

Drill-through 2

Child 2

revenue 2

cummulative dax 2

Navigation 2

DatesMTD 2

Previous Quarter 2

Tenure 2

running average 2

Orders 2

@PowerBI Report Server 2

power bi filter 2

X axis 2

Lists 2

card visualization help 2

Accumulate 2

exchangerate 2

Latest Status by DAX 2

Percentage of total 2

Performance Issue 2

"SEQUENCE" 2

Dax Studio connection error 2

dax code for calculated measures 2

Paginated Reports 2

Benchmarking 2

data model issue 2

Hierarchy slicer 2

FX 2

Margin 2

Stock Valuation 2

dynamic column names 2

weighted distinct count 2

Data Transformation 2

Empty 2

cohort 2

count of consecutive days 2

Fact 2

Missing Dates 2

SUMPRODUCT Measure 2

Date Parameter 2

Calculate difference consecutive rows 2

Multiple Values 2

Fiscal Week 2

NECESITO AYUDA 2

unrelated 2

@previous month 2

datamodel 2

firstnonblankvalue 2

comparing two different years. 2

big data 2

Help with DAX please 2

ranking on filtered page 2

Variable column 2

dax need help 2

Tips & Trick 2

"Prior Month" 2

Linear Regression 2

DAX for dynamic difference calculations. 2

measure filters 2

DAX Tips &Tricks 2

"multiple criteria" 2

Design 2

New Challenge 2

Data Visualization 2

error message 2

Grouped field 2

Expertise help 2

Extract 2

Summarize() 2

Group total 2

Likert scale 2

Operator 2

Top5 with Other column 2

bell curve 2

countblank 2

Concatenate columns in a measure 2

partial 2

"LOOKUP" "DATA" "PERIOD" "INTERVAL" "BETWEEN" "SELECT" "FILTER" "TABLE" 2

CONFIDENCE 2

indexing 2

Level of detail 2

Single Column 2

minutes 2

C 2

PowerBI Dax MAx 2

constant 2

CROSSJOIN UNION FILTER 2

CALCULATE TIME 2

Manage role 2

Bottom N 2

Not a number 2

SELECTEDMEASURE 2

"Consecutive" 2

@amitchandak 2

DRE 2

"Expression" 2

Salesforce 2

live dashboards 2

Edit In Power BI Desktop 2

Match 2

not equal to 2

drill 2

query folding 2

COVID-19 2

Market Share 2

custom sorting 2

Row Number in DAX 2

POP&L 2

Bin 2

Multiple Currency 2

isnonblank 2

@related @tables @relations 2

page filters 2

hierachy 2

ROUND 2

Measures to Columns 2

Date formatting to number 2

dynamic date 2

LTM 2

DAX text 2

large dataset 2

"SELECTCOLUMNS" 2

Asking help 2

Neep Help 2

DAX compare similar past period 2

@Parameter 2

Business 2

queries 2

Analysis Service 2

radar chart 2

else 2

Sparkline 2

slow rendering 2

testing 2

Line and clustered column chart 2

Group By For Two Columns in Dax 2

Window Function 2

customer concentration 2

Combine Values 2

Counting 2

Date Time 2

repurchase 2

segment 2

Future Dates 2

Help with Slicer. 2

Recent data 2

DAX groups or grouping values or text. Calculated columns 2

Max value in date range 2

Coloring 2

Measure DAX donut-chart axis countrows 2

sum row by row 2

Date context 2

Different Fiscal month 2

subcategory 2

multiple conditions 2

@WeekName 2

date calculations 2

"Maxdate" 2

dax measure error 2

CUSTOMCOLUMN 2

Formula with Multiple Conditions 2

Other 2

Subscription 2

timeline 2

sankey 2

while 2

Append measure to table 2

Search table columns for similair data 2

Technical question 2

available 2

Financial Year 2

su 2

conditonal formatting 2

rowlevelsecurity 2

actuals 2

Meausre 2

True 2

DAX to Power M Query 2

Transform data 2

COMBINEVALUE 2

zero 2

heed help 2

DAX for Time Tracking 2

exact 2

wrong 2

dataverse 2

balance 2

Recent date and time. 2

Rates 2

DATEADD and min function DAX 2

Get previous value 2

Assistance 2

Models 2

SWITH 2

period 2

DAX Window Function 2

DAXMeasure 2

Last Month 2

PowerBI Forecasting 2

@Calendar 2

Dax formaula 2

"if statement" 2

"Totals" 2

Bookmarks 2

Gantt 2

Memory 2

SAP 2

date ranges 2

multiple date tables 2

credit 2

Cross-Filtering 2

Line and stacked column chart 2

SUMPRODUCT 2

LostBusiness 2

Delimiters 2

@stock_managment 2

binning 2

DATEADD Visit Windows 2

concatenate within SWITCH() 2

Create Combo Chart 2

Count of Counts 2

consecutive 2

amount 2

RollingForecast 2

Rolling attrition 2

Waterfall 2

% of sales 2

Inventory Allocation 2

Filters based on context 2

DAX GROUPBY FILTER PERCENTILE.EXC 2

bucketing 2

@Power BI Report Builder 2

"Slicer" 2

Many to Many Relationship 2

Maximum value 2

"Dashboard Design" 2

% Growth 2

ignore 2

label 2

Format Date 2

Region 2

combine 2

mappings 2

Assigning Roles 2

Dynamics CRM 2

Total Sum 2

Custom Date Range on Date Slicer 2

expressions 2

@Ranks with Trend 2

Variation 2

Table cell background color 2

relative date slicer 2

newbie 2

dax calculated 2

multiplication 2

slicer selected column 2

@Slicer Date 2

IF(ISBLANK 2

percentage of column total 2

Virtual Relationships 2

time series 2

DAXformula 2

Conditional use of measures 2

@FORMAT 2

stop 2

table filtering 2

many-to-many 2

help dax 2

Many-to-relationships 2

USERPRINCIPALNAME 2

Many to One Relationship 2

"DAX create dynamic table from slicer " 2

Security 2

R 2

Reporting 2

automation 2

refresh data 2

power bi visuals 2

Managing Roles 2

delete rows 2

Replace Values Based on Another Column 2

fill empy cell 2

yield 2

reference 2

Case statement 2

STARTOFMONTH 2

percentage of total column 2

Power BI & Power Apps 2

scalar value 2

Price difference of identical products 2

CONCATENATEX() 2

Split Cost 2

DAX Measure TREATAS Child Parent Hierarchy 2

dinamic 2

hint 2

Want to create a calculated column 2

interactive visuals 2

Inventory Management 2

Hours 2

Filtered Measures 2

expanded table 2

DAX Grouping and Counting 2

New Column Formula 2

drill down 2

Groups 2

Strings 2

UserName 2

Shape Map 2

Approximate Lookup Dates 2

totals calculation not correct in matrix 2

new calculated table 2

SEQUENCE 2

cardinality 2

transform 2

direct query connection 2

unichar 2

QUOTIENT 2

longitude 2

Projections 2

v 2

QUICKMEASURE 2

Tips &Tricks 2

@100% stacked bar chart 2

IRR 2

PowerBI Countifs 2

higher education 2

TopN with Other 2

YTD on FiscalPeriod Filter 2

help and show 2

SUM of MIN 2

DAX count 2

Max per Category 2

Active Customer by Month 2

% difference 2

ranking multiple criteria DAX 2

Filter Function 1

visual card 1

campaign behavior 1

Show what filters are applied on the page 1

quick measures 1

custom arrows 1

Relational Table 1

DiretQuery 1

"dinamically" 1

Employee Exit 1

Accessing Tables 1

Date cal 1

Visualise differences 1

Learn Together 1

USERELATIONSHIP DAX Measures 1

codition 1

Need Nelp! 1

Sales Analytics for Dynamics Sales 365 1

Tips needed 1

Visual Table 1

Help please! 1

for each loop 1

"ISINSCOPE" 1

calculate rows 1

DateDim 1

@createtable 1

users 1

Pro Trial 1

Image URL 1

Analyze in excel 1

running-totals 1

CSV 1

Validation 1

Forex 1

where 1

% complete 1

Parameter formatting 1

MAQ 1

bigquery 1

spend 1

Cummulative Prev Change 1

DA 1

select all 1

Ordered Vs Delivered 1

add value from prior row measure 1

Access Control 1

file name 1

Rebasing 1

cumulative sum by multiple criteria 1

consecutive loss 1

subject line 1

color palette 1

compound 1

Average x month-13 1

change format 1

Merge files 1

Non Calendar FY and FQ 1

filtro de tiempo 1

help.me 1

maxium 1

sum duplicate dates 1

not null 1

amitchandak 1

Venn 1

- What 1

measure as legend in clustered chart 1

show missing record 1

Start and end week 1

start time 1

MeasureTable 1

duplicate error 1

graph title 1

field 1

rounding error 1

Joins 1

Memory Table 1

need h 1

help measure comparative 1

previous rows 1

SQL to PowerQuery 1

Day to Day 1

DRLS 1

week offset 1

Date Add Problem 1

not correct total 1

hiding values 1

if negative set 0 1

ackumulated sum 1

over due 1

fixed value 1

optimisation 1

rate 1

Home Page 1

Net Changes 1

area chart 1

year-over-year 1

@related 1

Nested DAX 1

pleasehelp 1

LY MTD 1

dynamic parameters 1

Average of Columns With Filters 1

@microsoft 1

Day of fortnight 1

Create a table and chart for open and closed based on different conditions for past 5 months 1

DAX Pattern 1

pace 1

static total 1

Current Selection 1

average employee 1

Dynamic date display 1

Power BI Average 1

Demand Planning 1

current week 1

WINDOW 1

need help in power query 1

static 1

Filters on Power Bi page 1

Granularity 1

Replicate or Duplicate same value in all rows till we find a revenue. 1

"Current time" 1

SKIP 1

disable Interactions 1

filter propagate 1

power bi bar graph averages 1

average as grand total 1

Percenatage 1

dynamic reference 1

along time 1

NEGATIVE HOUR 1

NAMEOF 1

@ssrs report builder help 1

Download Semantic Model 1

hints needed 1

@SQL 1

WebContent 1

dax meassure same row different column 1

inverted 1

"PYTD" 1

Count if 1

CountIFS to Dax 1

@Linestx 1

Web App 1

money 1

Advanced Analytics Visualizations 1

llo 1

Premium 1

Query String 1

rename 1

PBIX 1

Analytics 1

Visual suggestion 1

product function 1

default slicer value 1

mailchimp 1

Object level security 1

like to get 1

Please save me 1

Work days 1

10 1

Slow Reports 1

heed help on dax functions 1

kpis 1

PRICE_NAME SUM(CALLS_SUM) AD 12 1

change time format 1

Margin Percentage 1

Unique Measure. 1

NBA 1

Sample 1

Disconnected tables 1

YYYY-YY 1

Week End Date Calculation 1

dv 1

hyperlink 1

Automatic report 1

azure boards 1

filter interactions 1

structured references 1

coordinates 1

sum-sumx 1

Moving Range 1

SlicerCalendar 1

Index Calc relative to aggregate 1

measure issue 1

SHARED AXIS 1

Dynamic slicer 1

promedio movil 1

Quickbooks 1

stacked bar graph 1

damage percentage 1

Minus 1

Inventory Deduction 1

Two dates 1

outliers 1

advice 1

@api 1

multidime 1

ValidFrom 1

target store 1

dat 1

Custom Visuals Development Discussion 1

line cart 1

Quick Help Tip 1

|| 1

nested 1

common 1

discount 1

Moving Median 1

IF OR 1

"Power BI Old Version" 1

Reverse Total 1

Ranking Ties 1

"MTD" 1

Exists 1

work shifts 1

double relationship table dax 1

running totals splitted by positive and negative 1

Occupancy with Roomtypes 1

salesgoal 1

guide 1

@ Matrix Vizualisation Error In Calculation 1

Days in stock 1

current week filter 1

Prior 1

ASCENDING 1

Need your support @RLS 1

end of month 1

DAX factor based on date range lookup table. 1

Window Functions 1

Lord knows... 1

esay one 1

biggest 1

negative filter 1

multiple selections 1

calcualtetable 1

SUBSTR 1

Vertipaq 1

Dynamic Dates 1

best match 1

dynamic time range insight 1

Dataverse DAX 1

System Out Of Memory 1

multiselection slicer 1

subtraction of Row 1

Value for last month of Quarter for multiple selection filter 1

AVERAGE BY DAY 1

lost 1

Future Month 1

active count 1

pre selected filter 1

"create Table wit a distinct row with condition" 1

import 1

Management 1

l 1

Ideas 1

Mathematical 1

Help please 1

Scheduled data refresh 1

Scheduling 1

Faster reports 1

Language 1

First product order 1

repeat 1

Can't Display the Visual 1

Nee dhelp 1

IFNA excel funation alternative 1

inner join 1

pie chart tree 1

side by side 1

change variables 1

Roleplaying 1

Bundle 1

I'm losing my mind 1

20 1

Comcatenation 1

Row Average 1

Lowest Market Share 1

outbound delivery 1

741 ADM 14 1

hex 1

if and else 1

scalar 1

times 1

Current Year VS Last Year 1

email notification 1

Power BI Admin 1

@Greg_Deckler @Mich_J @amitchandak 1

Parameter Data Type 1

Basket 1

For Loop 1

by count 1

Advanced 1

hits 1

Thousand separator 1

ISCROSSFILTERED 1

Advanced Options 1

TimeSchedule 1

total amount 1

Dax Cumulative 1

Goals 1

I-MR 1

formatting cells 1

Decimal 1

DAX for %ROI 1

Random numbers 1

azure maps 1

Australian Date Format 1

monthly damage devided by all year profit 1

matrix view 1

Dates not required 1

larger 1

Fact Ta 1

validTo 1

target person 1

Filling data 1

retrive data 1

Rolling Skip 1

compounding 1

allocate $ 1

Rolling Totals 1

Parameters switch 1

self service reporting 1

measure fromat 1

Soma acumulada 1

@relations 1

Weekend 1

"bug" 1

What If Date 1

below 1

semi additive measure 1

custom viz 1

Networkday 1

work 1

transition 1

@ssrs 1

rolling 3 months average 1

near value 1

TOTAL IN THE LAST PERIOD AND SUBTRACTING THE VARIANCE FROM PRIOR PERIODS 1

Page Level Filters 1

u 1

ACC 1

User Actions 1

sum if 1

many to many relation ship 1

multiple substraction 1

"multi-value" 1

zero value 1

count dup 1

rolling count 1

smallest 1

Help with conditional formatting 1

"pivot table" 1

@quartiles 1

MID 1

duplicate to future periods 1

graficas 1

lastweek 1

Currency sign 1

single value slicer 1

filldown 1

"Hierarchies" 1

tree 1

"Loop" 1

disconnected date slicer 1

Filter Contex 1

LINESTX 1

Q&A 1

connect 1

login 1

background 1

Maximum number of values 1

new 1

monitoring 1

Editor 1

shared dataset 1

EXPORT TO POWERPOINT 1

automatic 1

last quarter 1

by 1

Power BI report builder 1

Proportion 1

suggestions on Data Analysis 1

Cound IDs 1

CD and CSD 1

not display data 1

507 AE 990 AEDU 201 AEM 4 1

annual 1

DAX formulas for total quantity matching 1

Previous Week comparison 1

Customer Revenue Comparison 1

PowerBIDesktop 1

invoice 1

by group 1

interaction 1

cumulative distinct count 1

Needl Help 1

overdue 1

number to text 1

MULTIPLESELECTION 1

DATA DON'T LOAD 1

true() 1

DateTime Math 1

Nextyear 1

Transactions for filtered customers 1

IMR 1

add up 1

ayuda 1

to date 1

card graph 1

DAX EVENT TABLE 1

OVERRIDE SELECTION 1

PARRALLELPERIOD 1

count of 1

DAX events in progress 1

per day 1

Cumulative ratesame month 1

reconstructing data 1

SELECTEDMEASURENAME 1

z-score 1

years 1

data decription 1

measure slicer 1

Dynamic Role 1

sensitive data 1

Demand 1

night day time comparison 1

Porcentagem Acumulada 1

@fact 1

MoS 1

Correcting subtotals 1

Fixed Year 1

PARITIONBY 1

items within orders 1

second largest 1

Nearest value based on other columns values 1

medida 1

Value of transaction 1

linechart 1

average measure 1

generateall 1

dax counter measure 1

Total sales by fisical date 1

accumulated 1

Pop-up 1

code optimization 1

dates range 1

system measures 1

calculate colun 1

CENSUS 1

"bitwise" 1

"Text" 1

payperiod 1

Date Conversion 1

parameteer 1

Single Select 1

POS 1

"INNER JOIN" 1

directqury 1

RIGHT 1

Dax summarizecolumns count items per group 1

año mobil 1

90th 1

detection 1

"Relationship with value less or equal than" 1

Need help on the Dax 1

Self-referencing 1

DAX for IF 1

Matrix Totals help 1

multiple selection 1

active per month 1

Dynamic Slicers 1

Scalar Types 1

tile 1

portfolio 1

R in Power Query 1

RankX issue with RLS 1

Permissions 1

Report server RLS row level security 1

category names 1

Data Mashup Error 1

Data Flows 1

scheduled 1

Video 1

imported 1

cube 1

loop up values from 2 tables 1

count 0 and 1 1

F 1

&& 1

INCORRECT CALENDAR 1

usage metrics report 1

Multiplication and wrong total in table 1

40 1

I need t 1

resets if 0 1

subtotal in a row 1

395 AEMD 2 1

conditional replace 1

hI i 1

Rolling inventory in each month associated with SKU 1

@countifs functionality @Need Helop 1

problem 1

14 day 1

completed 1

Preview Features 1

Last N Months Data 1

running a Query with two tables to show each row 1

QTR 1

Filter Pane Search 1

unique id 1

smoothing 1

help with hiding subtotal 1

Scenario Analysis 1

SUBSTITUTE 1

Workdays 1

Security Model 1

Need help on to the dataset id using filters 1

summerize 1

PowerBI calendar 1

write to SQL 1

Display Error 1

DAX forum 1

month by month 1

table totals 1

DAX Meas 1

text comma separator 1

Calculated Flag 1

RAG 1

European Microsoft Fabric Community Conference

Join the discussion

Helpful resources