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: DAX function

Join the discussion

Options

Mark all as New

Mark all as Read

Float this item to the top

Subscribe

Bookmark

Subscribe to RSS Feed

Showing topics with label DAX function. Show all topics

Get the average of a column value based on total c...

by Anonymous on ‎06-14-2022 07:28 AM Latest post on ‎06-16-2022 08:16 PM by v-chenwuz-msft

2 Replies 451 Views

2 Replies
451 Views

SQL to DAX conversion

by amikm on ‎12-28-2021 12:36 AM Latest post on ‎12-31-2021 09:09 PM by smpa01

10 Replies 2555 Views

10 Replies
2555 Views

Adding values on the same row from different colum...

by bradyl12 on ‎01-25-2021 01:26 PM Latest post on ‎01-25-2021 01:47 PM by AlB

1 Reply 789 Views

1 Reply
789 Views

Get lookup values based on multiple conditions

by Krish89 on ‎10-13-2020 02:57 AM Latest post on ‎10-14-2020 06:54 AM by DataInsights

3 Replies 4245 Views

3 Replies
4245 Views

Is possible to show One Metric with details and re...

by perezco on ‎05-29-2020 01:08 PM Latest post on ‎09-26-2020 10:19 PM by stevedep

5 Replies 1154 Views

5 Replies
1154 Views

Help for Maxx dax function error

by Thilini on ‎07-23-2020 04:05 AM Latest post on ‎07-23-2020 10:49 PM by Thilini

3 Replies 713 Views

3 Replies
713 Views

generate dax function running very slow , could yo...

by Chinnageddada on ‎06-24-2020 12:54 AM Latest post on ‎06-24-2020 08:35 AM by AntrikshSharma

1 Reply 358 Views

1 Reply
358 Views

Counting ELA and MATH

by syasmin25 on ‎05-29-2020 03:15 PM Latest post on ‎06-01-2020 10:30 PM by stevedep

12 Replies 1753 Views

12 Replies
1753 Views

DAX Help

by Anonymous on ‎05-26-2020 12:10 PM Latest post on ‎05-29-2020 11:26 AM by Anonymous

6 Replies 793 Views

6 Replies
793 Views

DAX: SubFigure logic to cater priority on date sli...

by XIOFEN_LIM on ‎04-29-2020 07:36 PM Latest post on ‎04-29-2020 10:24 PM by XIOFEN_LIM

2 Replies 531 Views

2 Replies
531 Views

Allow audience introduce goal manually for any mea...

by perezco on ‎04-28-2020 09:18 AM Latest post on ‎04-29-2020 09:54 AM by perezco

10 Replies 1402 Views

10 Replies
1402 Views

Take the latest value in a subcategory and roll it...

by Anonymous on ‎04-20-2020 03:53 PM Latest post on ‎04-21-2020 06:01 PM by Anonymous

2 Replies 1793 Views

2 Replies
1793 Views

Running total and sum of Running total

by Anonymous on ‎04-08-2020 01:53 AM Latest post on ‎04-12-2020 06:26 AM by Anonymous

3 Replies 477 Views

3 Replies
477 Views

New column

by RenataOGardner on ‎03-23-2020 05:34 AM Latest post on ‎03-23-2020 07:25 AM by RenataOGardner

6 Replies 665 Views

6 Replies
665 Views

Helpful resources

Top Labels

Alphabetical

DAX 3,772

Need Help 2,899

"DAX" 506

help 414

DAX Calculation 413

Need Help DAX 323

Filter 316

"Need Help" 310

Measures 289

"DAX help" 276

measure 267

Tips and Tricks 248

Help Requested 237

CALCULATE 225

Power BI 219

Show and Tell 215

Need Help DAX measure 190

DAX Commands and Tips 169

COUNT 148

Help appreciated 148

Help me please 147

Date 142

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 84

average 83

"Help" 82

Table 77

@dax @help 76

Power Query 74

@Daxhelp 74

@NeedHelp 71

dates 71

DAX Query 69

DAX help needed 69

Calculated columns 68

matrix 68

if 67

POWER BI Dax rules 67

DATEDIFF 64

sumx 60

LOOKUPVALUE 59

COUNTROWS 59

"DAX " 57

Filters 55

"MEASURE" 54

Formula 53

Conditional Formatting 52

TopN 51

"Calculated Column" 49

calculated column 49

"CALCULATE" 49

Help with DAX Measure 49

Matrix Visual 47

help needed 46

Desktop 45

General Comment 44

Max 44

DAX filter formula 42

Need Assistance 42

"Power BI" 41

SELECTEDVALUE 41

dax measure 40

"FILTER" 39

Power BI Dax 38

RLS 37

DAX Formulas 37

distinctcount 36

ALLSELECTED 36

Get Help 36

running total 36

Power BI Desktop 36

Filtering 35

MAXX 35

all 35

percentage 35

YTD 34

if statement 34

"DAX Commands and Tips" 34

Distinct Counts 34

Filter context 34

divide 33

ALLEXCEPT 33

DATEADD 33

@Power BI 33

PowerBI Desktop 32

switch 32

rank 32

@Dax Measure Error 31

groupby 31

DAX Filtering 31

ranking 31

Group By 30

values 30

DAX ALL PowerBI Excel 30

@Please Help 30

Running Totals 29

Distinct 29

"beginner asks Help" 29

Switch() 29

DAX Power BI 29

slicers 29

dax formula 28

USERELATIONSHIP 28

@help 28

'Need help' 'DAX' 28

"dax code" 28

Data Modeling 28

Hierarchy 28

column 27

Cumulative Sum 27

Urgent Help with DAX 27

DAX Command 26

needhelp 26

EARLIER 26

Aggregation 25

Virtual Table 25

Excel 25

Measure Column Total 25

datesbetween 25

DAX FILTER 25

All() 25

total 25

Calculatetable 24

Visual 24

Tips & Tricks 24

tables 24

SUMMARIZECOLUMNS 24

Dynamic 24

Compare 23

"DAX help" DAX 23

DAX tips 22

Totals 22

REMOVEFILTERS 22

Power Pivot 22

calculated table 22

Calculated Measures 22

blank 22

DAX RANKX 21

Data Protection 21

variables 21

@measure 21

" Slicer" 21

Date and Time 21

CONCATENATEX 21

Interesting Links 21

Cumulative Total 21

error 20

VAR 20

relationships 19

DAX. CALCULATE 19

calculation 19

time 19

@need help 19

Urgent Help 18

Format 18

MTD 18

Forecasting 18

lookup 18

@Conditional Formatting 18

Month 18

averagex 18

calculation groups 18

Need Help -DAX Measures 17

SQL 17

min 17

average of a measure 17

Dax commands help 17

calendar 17

DAX Time Intelligence 17

related 17

if condition 17

Need Dax 17

cumulative 17

dax functions 16

Top N 16

PowerBI Community 16

Circular dependency 16

Sameperiodlastyear 16

Line chart 16

"Time Intelligence" 16

chart 16

Date Table 16

"RANKX" 16

card 16

Dax studio 16

Formula Help 16

CONTAINS 16

MAX date 16

Cumulative Calculation 15

DAX SUMMARIZE 15

Need help (Using direct query) 15

COUNTX 15

Field parameters 15

If statements 15

Need Help in Power Bi 15

value 15

index 15

"DAX" "Earliest date" 15

@powerbi 15

conditional 15

Table Visual 15

columns 15

Calculations 15

Need Urgent Help 15

KPI 15

DAX Averages 14

Tips 14

duration 14

"CALCULATETABLE" 14

Direct Query 14

Slicer Visualizations 14

Related Tables 14

DAX Direct Query 14

DAX SWITCH 14

help in dax Function 14

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

AND 13

CUMULATIVE COUNT 13

variable 13

Tutorial 13

"Date Table" 13

Urgent 13

relationship 13

Date measures to filter data. 13

PowerQuery 13

Need help with DAX 13

Need DAX Help 13

Performance 13

DAX BUG 13

"Dates" 13

concatenate 13

sort 13

@measure filter 13

Optimizing DAX 13

LASTNONBLANK 13

Difference 13

question 12

TOTALYTD 12

Cumulative Totals 12

weighted average 12

"DAX " "DAX help" 'Need help' 'DAX' 12

rows 12

column calculation 12

condition 12

"average" 12

WEEKNUM 12

Rankx with filter 12

Tip & Tricks 12

Matrix table 12

Duplicates 12

Sumx() 12

Text 12

Visuals 11

minx 11

DAX Date condition 11

Advance DAX 11

subtotal 11

join 11

Slicer based on calculated Measure 11

DAX&Power Query 11

function 11

RANKX issue 11

Filter Table 11

date slicer 11

Commands and Tips 11

Calculation Group 11

Variable calculation 11

SUMIF 11

Measures to filter out 11

Dashboards 11

needs help 11

blanks 11

VLOOKUP 11

DAX Data Table 11

sorting 11

percentages 11

Row Level Security 11

"Calculation Group" 11

Hints & Tips 10

Please help 10

Formatting 10

Dynamic Ranking 10

averages 10

Rolling 12 Months 10

sales 10

budget 10

Moving average 10

currency conversion 10

Currency 10

Search 10

pareto 10

Data Modelling 10

DAX Optimization 10

General 10

COUNTIF 10

@PowerBI Report 10

Year 10

time functions 10

CONTAINSSTRING 10

datesinperiod 10

Last date 10

Median 10

DAX SUMX 10

DAX Syntax 10

@DateTime Functions 9

Tableau 9

DAX Hierarchy 9

Nead Help 9

ADDCOLUMNS 9

Report 9

Switch Metric 9

Previous month 9

context transition 9

Performance Issues 9

Loop 9

keepfilters 9

IF Functions 9

parameter 9

Power BI Help 9

category 9

SUM based on some filter 9

Parent child 9

PowerBI DAX 9

CountIfs 9

Weekday 9

M 9

isfiltered 9

measure based on slicer 9

DAX SUM 9

How To 9

PowerBI Help 9

row context 9

query 9

new column 9

'Need help' 9

grand total 9

subtotals 9

date calculation 9

dynamic table 9

group 9

Dynamic Date Period 9

grouping 9

@PowerQuery 9

SSAS Tabular 9

"DAX create dynamic table from slicer date" 8

Standard Deviation 8

Groupings 8

CALENDER 8

firstdate 8

INACTIVE RELATIONSHIP 8

FILTERS DAX KEEPFILTERS 8

OR 8

SSAS 8

Dynamic RLS 8

bar chart 8

Time interval 8

SQL to DAX 8

Merge 8

MoM 8

Conditional Formula 8

Calculate function with multiple criteria 8

what if parameters 8

Clustered Column Chart 8

crossjoin 8

COUNTA 8

Year over Year 8

Reports 8

.DAX 8

previous year 8

"Show and tell" 8

"Power Query" 8

target 8

TREATAS 8

legend 8

Average Grand Total 8

ORDER 8

@power bi desktop 8

Filter Multiple Column 8

LastDate 8

Row 8

@get help 8

Countdistinct 8

formulas 8

QTD 8

Need Help - Goals 8

Filter Multiple Columns 7

calculated tables 7

@ Matrix Visualisation Error In Calculation 7

isinscope 7

IF AND with multiple conditions 7

Tabular Model 7

Regression 7

Last Year 7

Table Column 7

Offset 7

DAX Language 7

Need Help re Measure Formatting 7

DATATABLE 7

logic 7

powerpivot 7

aggregate 7

rolling 7

Data model 7

Calculate dates 7

distinct count 7

M Query 7

multiple column 7

Inventory 7

syntax 7

DirectQuery 7

COLUMN VALUES 7

segmentation 7

custom column 7

Multiple columns 7

weekly 7

exclude 7

Categories 7

Between dates 7

parameters 7

Many to Many Relatioinship 7

multiple tables 7

Year to date 7

Advanced filtering 7

Iterator 7

DAX ALLSELECTED 7

relatedtable 7

tabular 7

unpivot 7

rolling sum 7

Maxdate 6

Show & Tell 6

Duplicate data 6

Visualization 6

Headcount 6

Percentage Difference 6

Calendar Table 6

"DAX SWITCH" 6

Power 6

beginner 6

churn 6

i need help 6

Month Calculation 6

SharePoint 6

percentile 6

previous 6

Summary 6

Divide Function 6

" Error Handling" 6

Latest 6

In 6

Filter based on context 6

sumifs 6

cummulative 6

recursive 6

@sumx 6

PBI Desktop 6

column selection 6

CALENDAR() 6

Division 6

matrix calculation 6

data 6

PBI 6

IF ELSE 6

union 6

ADDCOLUMNS() 6

dates between 6

duplicate 6

Conversion 6

Total not matching 6

RLS problems 6

isblank 6

DAX Total 6

optimize 6

Visual Filtering 6

conditional column 6

date filter 6

dax problem 6

previousmonth 6

today 6

COUNTAX 6

rolling average 6

'DAX' 6

Need Info 6

Calculated Measures Only 6

Networkdays 6

string 6

@visual level filter 6

"Date" 6

color 6

Variances 6

variance 6

Data Type 6

DAX Max Date within date range 6

Filter using a measure 6

"VAR" 6

"Power Pivot" 6

graph 6

Waterfall Chart 6

ID 6

dates table 6

Average from Matrix 6

"SELECTEDVALUE" 6

selected value 6

dax tip 6

tooltip 6

DAX TOPN 6

snapshot 6

dynamic filter 6

pivot 6

change 6

subtract filtered value 6

Total wrong 5

Dax Power Pivot 5

daxhelp 5

"FORMULA" 5

date format 5

cumulative value 5

pivot table 5

Statistics 5

Duplicate Values 5

Custom Measures 5

commands 5

Subtract 5

DAX TABLE 5

Average Rates 5

"SWITCH" 5

Gantt chart 5

max date problem 5

Desktop version 5

profit and loss 5

Week 5

Custom Time Intelligence Function 5

Hierarchical slicer 5

Modeling 5

Pie Chart 5

" cumulatives" 5

Moving average for measures 5

@inventory @DAX 5

Dynamic calculation 5

XIRR 5

Table variables 5

Conditional Sum 5

"Data Model" 5

drill through 5

need 5

Intersect 5

"MAX" 5

Working Hours 5

conditions 5

Week time intelligence 5

datesytd 5

new measure 5

calculate columns 5

Dax performance 5

DAX code 5

Help using powerbi 5

i 5

graphs 5

comparison 5

replace 5

Need help. 5

rolling 12 5

Unique Value 5

Nee help 5

"TOPN" 5

mdx 5

running balance 5

context filter 5

Path 5

Chart Help 5

tricks and tips 5

CODE 5

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

need helps 5

Measure Totals 5

"COUNT" 5

"DAX Query View" 5

Questions 5

Need Hepl 5

New Table creation 5

DAX Performace 5

MIN date 5

"Tips and Tricks" 5

line graph 5

measures in calculated columns 5

status 5

charts 5

Dynamic row level security 5

tutorial request 5

maximum 5

Need a help 4

Cohort Analysis 4

need Help with measure 4

P&L 4

dax variable 4

Dashboard 4

tickets 4

DATESYTD Help needed 4

cumulative sum by category 4

opening balance 4

HASONEFILTER 4

working days 4

IF THEN ELSE 4

dimensions 4

multiple rows 4

First Value 4

SCD2 4

DATESMTD() 4

Average by other column 4

DAX ROW CONTEXT 4

metric 4

bar charts 4

expression 4

AVG 4

Earlier Function 4

Custom Visual 4

Quarter 4

Product 4

status change 4

Direct Query mode 4

holidays 4

If Then 4

BINS 4

Date Calculation Error 4

New Table 4

Dimension 4

growth rate 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

Query Editor 4

Dynamic Index 4

WTD 4

Quarter over Quarter 4

NOT 4

Total Measure 4

Dax_Help 4

YoY calculation 4

"Dynamic Slicer" 4

metrics 4

weekly-averages 4

employee 4

Null 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

TopN Customer 4

SLA 4

Dynamic Flag 4

Power Query Editor 4

stock 4

Conditional Formatting column 4

"subtotal 4

PREVIOUSDAY 4

@average 4

"Time" 4

distribution 4

Live Connection 4

Composite Model 4

Total wrong in matrix 4

utilization 4

Custom Filter 4

Calculatetable filter 4

DAX Relationships 4

@ 4

monthlyaverage 4

DAX Filtering Slicer 4

Need help for Dax 4

Model 4

Visualisations 4

yoy 4

range 4

Advanced Visualization 4

% 4

OR function 4

salary 4

dax calculations 4

Dynamic filters 4

advanced dax 4

tutorials 4

multiple 4

selected values 4

hasonevalue 4

result 4

conditional columns 4

Histogram 4

summarize table 4

Tabular Editor 4

calculated 4

delta 4

DAX Divide Formula 4

"Grand Total" 4

finance 4

Rolling Months 4

Runnig Total 4

Sum & Totals 4

Functions 4

Conditional Totals 4

Hierarchy of matrix 4

Customer 4

Dynamic Column 4

What If 4

Security roles 4

WOW 4

many to many 4

stacked bar chart 4

count rows 4

Fiscal Year 4

SVG 4

rolling dates 4

multiple filters 4

Split column 4

Weekday calculation 4

cumulative total - running total 4

bridge table 4

@Show and Tell 4

@slicer 4

update 4

previous week 4

Measure Multiplication 4

Cumulative Totals by category 4

Average Sales 4

weighted 4

dataset 4

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

Financial 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

DAX table filter 3

Previous row value 3

ratio 3

DAX Equation 3

Convert 3

%grand total 3

minimum 3

How-to 3

BI Vs Tableau 3

Lookupvalues 3

empty columns 3

Userrelationship 3

Control charts 3

Customers 3

hour 3

Fiscal Calendar 3

Slow Performance 3

Virtual Tables 3

Combining two Rank measures by category 3

normalize 3

Dynamic data selection based on date 3

facts filtering dimensions 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

Add Column 3

benchmark 3

complex 3

relations 3

Text Measure 3

Analysis in Excel 3

DAX Division with Date 3

Intersection 3

Nested IF 3

DAX. 3

visual level filter 3

Flow 3

Retention 3

XLOOKUP 3

Except 3

firstnonblank 3

attrition 3

DAX Measur 3

Burndown 3

CURRENTGROUP 3

field parameter 3

Earliest Date 3

lost customer 3

"category" 3

slow 3

negative 3

Counter 3

DAX for max utilisation 3

financial report 3

Find multiple values 3

HR 3

Lookup value 3

Date Function 3

Inventory Planning 3

drillthrough 3

General Comments 3

Count rows (date) by month 3

SUM of MAX 3

Day of Week 3

Date DIFF 3

new calculated column 3

New quick measure 3

Days 3

Summary Tables 3

Help me to find this DAX 3

Column Comparison 3

survey data 3

Dax Join 3

Visualizations 3

"aggregations" 3

basket analysis 3

monthly growth 3

Select 3

dynamic filtering 3

@tables 3

complex dax 3

@divide 3

DAX Dynamic Top N 3

Running Balances 3

BUG 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

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

Filter two tables 3

DAX CALENDARAUTO() 3

Calander 3

Start and end period 3

range of values 3

Role level security - multiple levels 3

API 3

Calc column assistance 3

two tables 3

date interval 3

Column Chart 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

ALL Function 3

@PowerBI Report. @dax 3

e 3

Max date from select dates in Dataset 3

date range 3

fortnight 3

General Question 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

dynamic data filtering 3

analysis services 3

dax mode count 3

calculated rows 3

weighted averages 3

sort formula 3

PARTITION 3

find 3

Conditionals 3

@Cummilative 3

DAX FILTER ISSUES 3

accumulated measure 3

DAX SUMMARIZE FILTER GROUPBY 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

grand total row incorrect 3

EarlierFunction 3

weeks 3

LOD 3

virtual 3

Previous Row 3

time calculation 3

mapping 3

% CHANGE 3

R script 3

guidelines 3

tooltips 3

transpose 3

SUM of Units 3

unique 3

Power Automate 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

text filter 3

Azure Analysis services tabular model 3

Absolute Value 3

active customers 3

PBIX Reports 3

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

Asking help 2

Neep Help 2

Design 2

New Challenge 2

Data Visualization 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

Group By For Two Columns in Dax 2

Window Function 2

customer concentration 2

Combine Values 2

Counting 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

" cumulative " 2

DAX compare similar past period 2

@Parameter 2

Salesforce 2

live dashboards 2

Issue 2

radar chart 2

else 2

Sparkline 2

slow rendering 2

testing 2

Line and clustered column chart 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

@WeekName 2

date calculations 2

"Maxdate" 2

dax measure error 2

CUSTOMCOLUMN 2

Formula with Multiple Conditions 2

Business 2

queries 2

Analysis Service 2

timeline 2

sankey 2

while 2

Append measure to table 2

Search table columns for similair data 2

Technical question 2

available 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

PowerBI Forecasting 2

@Calendar 2

Dax formaula 2

"if statement" 2

"Totals" 2

Other 2

Subscription 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

@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

Maximum value 2

"Dashboard Design" 2

% Growth 2

'Cumulative totals' 2

ignore 2

"Calculated Columns" 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

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

Many-to-relationships 2

USERPRINCIPALNAME 2

Many to One Relationship 2

"DAX create dynamic table from slicer " 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

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

Help! 2

DAX count 2

Max per Category 2

Active Customer by Month 2

% difference 2

ranking multiple criteria DAX 2

Filtered Measures 2

expanded table 2

DAX Grouping and Counting 2

New Column Formula 2

Security 2

R 2

Reporting 2

UserName 2

support 2

Shape Map 2

Approximate Lookup Dates 2

totals calculation not correct in matrix 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

need help in DAX 2

filtered values 2

filter propagation 2

Dax power query 2

Column Formula Assistance 2

drill down 2

Groups 2

Strings 2

loading 2

link 2

Icons 2

Events in progress 2

percentiles 2

Summerizecolumn 2

fiscal period 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

blank values 2

fact table 2

Max Values 2

Request 2

outliers-detection 2

selection 2

Sum on a dynamic date range 2

Data Analysis 2

new measure of % by group 2

contract 2

sum of measure 2

match value 2

power-BI 2

Prior year filtering 2

empty cells 2

Filtered table 2

DAX tables 2

"Time Conversion" 2

"Power Automate" 2

Remove Filters 2

"parameter" 2

"M Query" 2

Content 2

Quick Tips 2

database 2

axis 2

Missing data 2

dropdown 2

Age 2

dependency 2

KPI Indicator 2

Past & Current Month Latest data 2

Decomposition Tree 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

RELATED() 2

@ excel table 2

DAX AVERAGE 2

Measure Help 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

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

"CHART" 2

Map 2

Paginated Report 2

targets 2

New Help 2

Filter Changes 2

weekdays 2

custom formula 2

Substract with a measure 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

daX ERROR 2

"Multiplication" 2

Auto-exist 2

ProductX 2

compare row value. 2

date slicers 2

Power BI Data 2

gauges 2

filter pane 2

searching from 2 tables 2

addcolumn 2

return 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

"Tutorials" 2

Excel formula to Dax 2

gateway 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

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

"SEQUENCE" 2

Dax Studio connection error 2

dax code for calculated measures 2

Mysql 2

User 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

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

"Prior Month" 2

Linear Regression 2

DAX for dynamic difference calculations. 2

measure filters 2

DAX Tips &Tricks 2

"multiple criteria" 2

Paginated Reports 2

error message 2

Grouped field 2

Expertise help 2

Extract 2

Summarize() 2

Group total 2

Likert scale 2

Operator 2

90 1

deadline 1

tMonth 1

overlaying graph 1

running 1

true () 1

rangos 1

Dynamic slicer flag column 1

Power M Query 1

Deaths 1

Past Due 1

Expanded Tables 1

av 1

Open 1

I will pay you 1

Last purchase price 1

DAX Ca 1

filtre 1

True False Expression 1

Generate 1

two dimdate tables 1

files 1

Monthly 1

comma 1

logical or 1

returning customers 1

next 1

Debits 1

Copying Data 1

next 7 days 1

MDX forums 1

iserror 1

Stage 1

BW 1

Exclude from measure 1

Filter by two combinded columns 1

sprint planning 1

selectitem 1

afteron shift 1

how can we concatenate columns dynamically using DAX 1

MovingAverage 1

Create column 1

relativity 1

Show current week 1

Help in adding and dividing column total 1

Data error 1

first entry of the day 1

dynamic count 1

"SELECTCOLUMNS" 1

WeeklyTotal 1

Detail Row Expression 1

facttables 1

Counting comma deiminated text strings 1

Scaled score 1

Time intelligence function 1

sum of rows 1

calcuations 1

iterating 1

Minute 1

Default value 1

ranxk 1

prior date 1

Legends 1

filter measure 1

Stop rounding 1

starting balance 1

"SSAS" 1

seasonality visual 1

clustereaaa 1

RelationshipFunctions 1

DAX for Power bi 1

VALUES() 1

last12months 1

RELATE 1

Slicer with measure 1

lastvalue 1

DAX_Subtotal 1

Powerbi dax help 1

hekp 1

Dax measure for conditional color for Lines 1

"Format" 1

DaxQuery Total 1

same store sales 1

QtoQ 1

last 12 months 1

CAX 1

ParentChild 1

Power BI Service 1

URL 1

access 1

formating 1

Boolean 1

Counting Same Data that Occurs over Multiple Years 1

kcantor 1

ALLCROSSFILTERED 1

cross report drill through feature 1

funnel plots 1

Share Valuation 1

financial data 1

SPC DAX XMR chart Control limits 1

Nonlinear Regression 1

'SYNTAXERROR' 1

Ties 1

Line & Stacked Column 1

Help to update datasource 1

Relations management 1

BusinessCentral COA Totalling 1

work load 1

chart axis with no data 1

Tag rows 1

org chart 1

Date Time 1

simulation 1

Report Data 1

KEEP 1

record 1

Reverse Cumulative 1

Invoices 1

availability 1

Rolling 6 months data 1

Close and Backlog Tickets 1

Historic Table 1

Stocks 1

Compare quarter wise data 1

date axis 1

PBI SQL SERVER 1

cds 1

Null to Zero 1

selected 1

Direct Active Relationship 1

National Insurance 1

injury 1

userelationship rowlevelsecurity 1

secondary y-axis 1

self query 1

interpolation 1

override filter 1

Difference in one Column 1

Cumulative Emissions 1

Power BI Desktop for Report Server 1

col 1

Speedtime 1

@paginated report 1

poor 1

ISEMPTY 1

Measure excluding 1

cross check 1

for 1

Operating Profit 1

Last Week 1

header 1

Tableau to DAX code 1

colors 1

Mont to Date 1

hide small values 1

textdisplay 1

jbs 1

fiscal month Dax 1

Queue Theory 1

FIRST 1

Filtered Average 1

Interval 1

percentage and slicer 1

slicing 1

CalculateCostPrice 1

kimball 1

Power bi community 1

جلب+الحبيب+السعودية 1

before 1

posting period 1

line 1

"Ayuda" 1

finding first record 1

column from another table 1

Pwoer bi 1

"DAY LAG" 1

roll up 1

Exclusion rule in DAX 1

filter using measure 1

Measurement 1

unique days 1

weekrank 1

5-year avg % 1

erB 1

Banding 1

remaining 1

barchar12month 1

orderby 1

public holidays 1

"VALUES" 1

variable not working in condition 1

Visual Calculations 1

Categorizing 1

min iterating value 1

@see and tell 1

Weekly data analyzing Power BI 1

Sales vs Target 1

Table View 1

community 1

Education 1

1 1

external users 1

Dynamics 365 1

123 1

Dataflows 1

iamprajot 1

Power Apps 1

Unhandled 1

changing classifications 1

Stock In Hand 1

Replace Text Based on Another Column 1

ONE TABLE MODEL 1

Issues 1

TopN by Store 1

Atingir Meta e Solver 1

filter direction 1

Refreshing 1

To Show Ratio 1:2 1

remote computers 1

NewBusiness 1

volume concentration 1

DAX formula for tracking daily death cases 1

Password 1

Alias on summ 1

Conteo 1

webpagelinking 1

Error Handling 1

non-zero 1

- B 1

Historic Data 1

MEDIDAS CON FECHAS 1

hires 1

show all values 1

"Time update" "Report" 1

Empty rows 1

gap 1

drill up 1

longitudinal 1

duplicaterows 1

Powerbi Report Builder 1

measure in "column field" of matrix visual 1

attrition Rate 1

rolling values 1

merged 1

Differencies 1

perofrmance 1

Sub-Totals 1

bonus 1

exclude intersection 1

Value of last transaction 1

need help to pull latest msg 1

relativepath 1

months 1

think cell 1

averaging 1

Message 1

leegend 1

component 1

cell elements 1

people analytics 1

Last month value 1

max by category 1

Help with Deneb 1

MatrixChart 1

exception 1

QoQ 1

suggestions 1

PC_Power BI. 1

different times 1

Last Month 1

stacked column 1

crosscheck 1

after 1

normalized score 1

cheapest value per group 1

Nee 1

clientes 1

Partitions 1

comma seperated 1

Measure Table BOM 1

@MTD 1

Complicated 1

excluding overlaps and gaps 1

Totals Blank 1

year avg% 1

help total 1

True-False 1

divide same measure 1

Remove Duplicates over 2 columns 1

dynamicfilter 1

@unpivot 1

Totals Incorrect 1

DAX groups or grouping values or text 1

LTIFR 1

Sum with multi level filters or groups 1

Measure Title 1

task completion 1

Account Trial Balance 1

allocation overhead 1

"powerbi" 1

schedule 1

Power Bi Reports 1

Active Directory 1

Schedule Refresh 1

Sync Slicer 1

slicer value used in a different way 1

Data Security 1

scatterplot 1

ovetteabejuela 1

subgroups 1

12 month 1

one row 1

PaginatedReports. ReportServer 1

Time Zone 1

aaa 1

Analysis Server 1

ALLSELECT SURVIVAL RATE 1

Nominator 1

Dinamic rows 1

Top5 and Bottom 5 1

able 1

concentration curve 1

perce 1

Error of Expression Refers to multiple columns. Multiple columns cannot be converted to scalar value 1

optimised 1

filtrar 1

Multidimensional 1

math 1

unico 1

ifelse 1

help wanted 1

Previous YTD for Ranked Sales 1

Summing Measures 1

Intersect() 1

hierarchy slicer merge text 1

Outstanding 1

Store Data 1

Metric Switch 1

Output 1

same table 1

project for the web 1

intervalmatch power bi 1

maria db 1

Weighted Average Price 1

nullby0 1

Text Box 1

Seriallabel 1

Nested Filter 1

DAX _ Moving Average 1

percentage of row total 1

sickne 1

Day of the Week 1

selectedvalue in Data Table 1

multiselect 1

Year-to-Date calculation 1

sum of row non zero 1

Previous time 1

User error 1

studio 1

Dax_Functions 1

compensation. calendar. 1

holiday 1

help. 1

optimizing 1

only show value based on criteria 1

Row-Level-Security 1

Retrieve Data 1

transfers 1

not display 1

clean up 1

Customer Sort 1

"current day" "function AND" 1

counting anything>24 hours 1

sort order 1

IFBLANKS 1

DAX: Trailing average 1

YTD cumulative stopping based on certain date 1

Time func. 1

card visual 1

Yesterday 1

Count Partition 1

@PowerBI Builder Paginated Report 1

DinamicMeasure 1

Large Datasets 1

modifier 1

count multiple conditions 1

concatenex 1

Custom Bar and Line graph 1

Confidence Interval 1

IF Power BI 1

Record comparison 1

dax groups 1

Month Format 1

Average of value at filter date and specified or previous year-end date 1

EVALUATE 1

day% 1

same 1

result of a measure 1

Human Resources 1

Bridge Tables 1

Measure that tracks change 1

dax lastnonblank 1

actual 1

"relationships" 1

TRIFR 1

@PaginatedReports 1

reset 1

Working Time 1

compare strings 1

"% Increase" 1

Cards 1

survey 1

Embed 1

delete 1

Test 1

data refresh 1

Feature Comparison 1

oracle 1

Json 1

Focus slicer 1

v-qiuyu-msft 1

helps 1

Custom Time Period for Dataset 1

Icon Formatting 1

transformation 1

child objects 1

correct visuals 1

total zero 1

bad data 1

in chosen periods 1

title 1

azure devops 1

Denominator 1

show statusRDP 1

Previous Month Last Year Card 1

daily difference 1

ReturningBusiness 1

customer percentage vs sales percentage 1

Every 1

@Add comments 1

time format 1

Filtering using URL 1

exponent 1

Transliteration 1

first per day 1

Load Time 1

unix 1

change logs 1

apply 1

B 1

Python script 1

Advanced editor 1

extract date 1

unique values to date 1

business day 1

DMV 1

last value 1

LOOKUPVALUE() 1

plan values 1

Year to week 1

Spreading cost 1

@conditional format 1

Find new 1

"label" 1

Tips&Trick 1

Dax.do 1

Excluding unreported quarters 1

Order in hand 1

YY:MM:WW:DD:HH:MM:SS Formatting PowerBI 1

RANKX to exclude Blanks 1

SharePoint Excel 1

ranges 1

command 1

Excluding 0 1

Quantity 1

Date Divison 1

Part Time 1

8020 1

Reset calculation date range based on condition 1

des 1

each 1

filter between tabels 1

linear line 1

relative measure 1

New column - based on value in another table 1

tank 1

Distribute 1

current 1

year before last 1

Month to date 1

user name 1

DAX Script 1

Filter and Use different value from different tables 1

@gateway 1

"IN VALUES" 1

fictive 1

Rosario 1

Top N plus others 1

"And filter" 1

filter non aggregate data using dax 1

visualti 1

Datefunctions 1

Date Shift 1

looping values 1

YTD Switch 1

past month 1

h 1

capitalized 1

piechart 1

Data Masking 1

price 1

Yesterday's Data 1

workflow 1

MinValue 1

Star Schema 1

dinamic column selection on powerquery measure context 1

ChurnMRR 1

First Quartile 1

Edate 1

DAX Issues 1

@Measures 1

weekly sales 1

"Categories" 1

labels 1

General Info 1

Data Science 1

How 1

Azure 1

scale 1

SQL Server Database 1

repeated 1

links 1

D3 1

row_number 1

Usage Metric 1

stage change 1

Production 1

debit 1

include 1

Need to mark holidays in calendar 1

DAX com 1

Customer Items 1

have 1

remote desktop connection 1

Performance issues with AverageX 1

Day on Day 1

using 1

multiple join 1

ISNUMBER 1

12 hour 1

@redshift 1

background color 1

static value 1

List value account 1

Mongodb 1

Workout Wednesday 1

array 1

order time 1

FPY 1

Change Default Setting 1

rolling 12 month 1

Suma del promedio 1

hide blank 1

Column Number 1

more than 2 tables 1

Fill 1

Image in DAX 1

Velocity 1

DMV Query 1

@Incorrect slicer date showing 1

Conditio 1

YTW 1

SQL Server Analysis Services 1

@custom visuals 1

DateTime 1

graduation rates 1

link tables 1

condition other table 1

Formatted Table 1

churn rate 1

@paginatedreport 1

Bottom M 1

Power BI Calendar Tables 1

SUM WITHOUT CHILD 1

MariaDB Connetor 1

DAX Fechas 1

controlling 1

count events 1

allocating quantities 1

MROUND 1

Recursiveness 1

forcasting 1

majority 1

Amounts 1

Formulae 1

Staff 1

past 1

previous value 1

Custom MTD 1

capitalise 1

Index Starting at 1 for any slicer selection 1

Parameter Query 1

Convert total revenue into K 1

phone call 1

opening balance from dax 1

age groups 1

countrows sumx 1

hour between rows 1

CASEWHEN 1

slicer by measure 1

Customer purchase behavior 1

filter on tooltip 1

Card (new) 1

redeployment 1

anual growth rate 1

Group by measure in colum 1

Inheriting 1

processing 1

except() 1

Fact Tables 1

Week-to-date 1

Vlookup Dax Help 1

Crear Tabla DAX 1

Direct Query Performance DAX Measure 1

Price effect 1

IFStatement 1

Longer Week 1

7D AVG 1

"Spanish" 1

bars 1

Extreme weather 1

Best Practices 1

Roundup 1

Roles 1

Embed Report 1

Data Source 1

timeline slicer 1

numbers 1

default 1

logs 1

. 1

incorrect 1

[help needed] 1

last date time refresh 1

dashboard dax help 1

opportunity stage 1

Match calculated ranking column 1

multi-value 1

Gateway issue 1

reference text 1

Clustered 1

Previous Date 1

dynamic percentage calculation 1

Alternatives for AverageX 1

have a 1

mailto 1

Realtotals 1

consolidation 1

a da 1

one slicer to filter another table 1

24 hour 1

predictive models 1

Measure name change based on year selected in Slicer 1

NoData 1

FirstPass 1

leapyear 1

Score an account 1

% of total 1

Decile Rank 1

BOM 1

row based measure 1

past week 1

syncing 1

partial text 1

replacenullvalueinmatrix 1

New Member 1

Hide Bars 1

Different result 1

compare query 1

null value 1

Penultimate date 1

Custom Sort 1

time slicer 1

measure lookup 1

Error Code 1

Others Category 1

by month 1

Report Performance 1

trending 1

exclusions 1

DAX DirectQuery No. of days between two dates 1

evolution 1

List of slicer values 1

SQL into DAX 1

per employee 1

Time Delta calculations 1

distribute amount 1

100 1

variable length 1

Fortnightly 1

fiscal month 1

Pattern 1

tips format 1

like the image 1

inventory value 1

running count 1

average count 1

Custom table 1

call center 1

Find % Of Total lines with Specific Filtered Applied 1

age labels 1

summarizing 1

Special Dates 1

no effect 1

purchase after initial purchase 1

tally 1

Payroll Projections 1

Dynamic arrows 1

Slicer values 1

Dropdown Slicer 1

stock transfer 1

"pbi" 1

null values 1

double 1

occupancy 1

matched pairs 1

CircularDependancy 1

Startofweek 1

WorkingDays 1

D 365 Sales 1

Event Occurence 1

previous day

European Microsoft Fabric Community Conference

Join the discussion

Helpful resources