Join the discussion

Concatenate a field within IF/SWITCH statement

by on Latest post on by

1 Reply 119 Views

1 Reply

119 Views

Helpful resources

DAX 1,227
Need Help 605
DAX Calculation 226
Measures 155
Filter 119
Need Help DAX 117
help 96
measure 87
CALCULATE 80
Need Help DAX measure 79
Help Requested 77
Power BI 69
Dax Help 67
COUNT 56
Date 52
Help me please 51
RANKX 46
DAX Commands 45
DAX Query 45
Help with DAX 43
DAX Commands and Tips 42
Time Intelligence 39
DAX filter formula 38
Help required 38
Tips and Tricks 38
Table 35
POWER BI Dax rules 34
average 34
SUMMARIZE 32
sum 32
Calculated columns 31
Help me 28
Slicer 27
Show and Tell 23
dates 23
DAX Measures 23
dax measure 22
if statement 22
Matrix Visual 22
DATEDIFF 22
Power Query 22
Help with DAX Measure 22
Filtering 21
Formula 21
TopN 21
Filters 20
sumx 20
Date and Time 20
distinctcount 19
if 19
Conditional Formatting 19
@NeedHelp 18
LOOKUPVALUE 17
Power BI Dax 17
running total 17
YTD 16
percentage 16
PowerBI Desktop 16
Get Help 15
ranking 15
help needed 15
Switch() 15
Desktop 15
@Dax 15
Help appreciated 15
Distinct 15
dax functions 14
DATEADD 14
matrix 14
Calculatetable 14
ALLEXCEPT 14
calculated column 14
powerbi 13
RLS 13
ALLSELECTED 13
values 13
COUNTROWS 13
SELECTEDVALUE 13
all 13
DAX. CALCULATE 13
divide 13
switch 13
DAX function 12
Measure Column Total 12
Filter context 12
Distinct Counts 12
Max 12
help in dax Function 12
hierarchy 12
Month 11
DAX For Filter 11
if condition 11
DAX Filtering 11
Cumulative Sum 11
tables 11
Tutorial Requests 10
time functions 10
averagex 10
Compare 10
@Please Help 10
VAR 10
USERELATIONSHIP 9
Need help (Using direct query) 9
average of a measure 9
DAX Time Intelligence 9
groupby 9
Aggregation 9
Virtual Table 9
column 9
Dax commands help 9
measure based on slicer 9
column calculation 9
rank 9
Dynamic Date Period 9
Related Tables 9
Date measures to filter data. 9
DAX ALL PowerBI Excel 9
datesbetween 9
Urgent Help 8
Matrix Visualisation 8
Year 8
MAXX 8
columns 8
General 8
Difference 8
EARLIER 8
Interesting Links 8
Cumulative Totals 8
Need Help - Goals 8
Power Pivot 8
cumulative 8
blank 7
index 7
TOTALYTD 7
value 7
POWER BI DATA VİEW 7
Data Modeling 7
Totals 7
DAX Direct Query 7
Group By 7
join 7
KPI 7
Table Visual 7
@dax @help 7
min 7
needhelp 7
time 7
conditional 7
Urgent Help with DAX 7
All() 7
Tip & Tricks 7
variables 7
slicers 7
crossjoin 7
calculated table 6
card 6
Calculations 6
total 6
dax formula 6
Top N 6
currency conversion 6
calculation groups 6
Date Table 6
Visual 6
Running Totals 6
Variable calculation 6
MTD 6
PowerBI Community 6
percentages 6
CountIfs 6
CONTAINS 6
SAME PERIOD LAST YEAR 6
Need Assistance 6
DAX RANKX 6
Slicer Visualizations 6
SQL 6
forecast 6
SUMIF 6
MAX date 6
SUMMARIZECOLUMNS 6
Direct Query 6
rolling 12 5
keepfilters 5
pareto 5
Tips 5
Tips & Tricks 5
lookup 5
change 5
REMOVEFILTERS 5
variable 5
date slicer 5
VLOOKUP 5
Performance 5
Measures to filter out 5
grouping 5
multiple column 5
SSAS 5
AND 5
DAX BUG 5
Need Info 5
Optimizing DAX 5
Dynamic 5
tabular 5
Average Grand Total 5
subtract filtered value 5
today 5
SQL to DAX 5
context 5
date calculation 5
datesinperiod 5
QTD 5
Many to Many Relatioinship 5
PowerBI Help 5
DAX Data Table 5
group 4
dynamic table 4
Forecasting 4
Last Year 4
Weekday 4
averages 4
SSAS Tabular 4
chart 4
weekly-averages 4
Loop 4
column selection 4
budget 4
IF ELSE 4
Need Help re Measure Formatting 4
CONCATENATEX 4
rows 4
Format 4
Summary 4
Filter Multiple Column 4
Formatting 4
relationships 4
@get help 4
Report 4
Text 4
isfiltered 4
crossfilter 4
Visual Filtering 4
M Query 4
ID 4
Direct Query mode 4
sumifs 4
dates table 4
rolling 4
Year over Year 4
Sumx() 4
multiple tables 4
Dax studio 4
Power BI Desktop 4
query 4
Performance Issues 4
M 4
LASTNONBLANK 4
related 4
DAX Syntax 4
optimize 4
COUNTX 4
dax tip 4
@need help 4
cumulative value 4
Switch Metric 4
Search 4
Rankx with filter 4
context filter 4
Sameperiodlastyear 4
minx 4
subtotals 4
snapshot 3
PBI Desktop 3
Calc column assistance 3
firstdate 3
hasonevalue 3
weighted averages 3
Moving average 3
DAX SWITCH 3
rolling dates 3
General Question 3
@Dax Measure Error 3
distribution 3
calendar 3
SLA 3
condition 3
INACTIVE RELATIONSHIP 3
unpivot 3
Countdistinct 3
Runnig Total 3
DAX tips 3
Nead Help 3
General Comment 3
Pareto Chart and table by Period help 3
Groupings 3
Last date 3
Dashboard 3
selected values 3
multiple rows 3
Data Protection 3
Standard Deviation 3
range of text 3
ADDCOLUMNS() 3
Cumulative Total 3
tutorials 3
Slicer based on calculated Measure 3
CUMULATIVE COUNT 3
DAX Language 3
cohort 3
recursive 3
Visualization 3
duration 3
Rolling Months 3
Days 3
mdx 3
bar chart 3
Conversion 3
date interval 3
cummulative 3
Calander 3
calculation 3
line graph 3
sorting 3
Unique Value 3
union 3
row context 3
Excel 3
SUM of Units 3
previous year 3
Row Level Security 3
percentile 3
metrics 3
calculated rows 3
Total wrong in matrix 3
relatedtable 3
WEEKNUM 3
function 3
custom column 3
DAX help needed 3
dax mode count 3
Field Value 3
Data Modelling 3
Variances 3
FILTERS DAX KEEPFILTERS 3
Waterfall Chart 3
Merge 3
previous 3
bar charts 3
Filter based on context 3
help with date 3
COUNTIF 3
Quarter over Quarter 3
Dax Join 3
Cumulative Totals by category 3
color 3
Line chart 3
what if parameters 3
Composite Model 3
running balance 3
exclude 3
concatenate 3
holidays 3
subtotal 3
Circular dependency 3
drillthrough 2
New Challenge 2
Azure Analysis services tabular model 2
selection 2
while 2
negative 2
drill 2
Dimension 2
cumulative sum by category 2
Integer 2
sort formula 2
LastDate 2
weighted 2
sort 2
segment 2
dates between 2
Power 2
column total 2
range 2
Max date from select dates in Dataset 2
date ranges 2
aggregate 2
conditional columns 2
Advanced filtering 2
partial 2
BINS 2
update 2
Analysis Service 2
Visualisations 2
Power BI Help 2
tutorial request 2
weighted distinct count 2
count distinct with condition 2
multiple date tables 2
custom formula 2
Data Type 2
grand total row incorrect 2
Networkdays 2
e 2
complex 2
searching from 2 tables 2
Tableau 2
Average Sales 2
Start and end period 2
cummulative dax 2
Running Total Weekly 2
expression 2
New Help 2
Urgent 2
timeline 2
TOTALYTD through Today 2
cumulative percentage 2
Need Hepl 2
M language 2
Total Sum 2
previousmonth 2
Custom Filter 2
Last 2
CALENDAR() 2
How To 2
unique 2
DAX for max utilisation 2
% 2
sumtotal 2
OR function 2
Time interval 2
analysis services 2
DirectQuery 2
parameters 2
employee 2
In 2
grand total 2
Ignore Slicers 2
Week time intelligence 2
DAX Hierarchy 2
pivot table 2
fiscal 2
NOT 2
live dashboards 2
i 2
gauges 2
Count rows (date) by month 2
Multiplying by Sum 2
tricks and tips 2
Search table columns for similair data 2
grouped 2
Except 2
commands 2
WTD 2
Calculatetable filter 2
Duplicate data 2
dynamic filter 2
Desktop version 2
Previous month 2
Summerizecolumn 2
New Table creation 2
Total not matching 2
available 2
YoY Line Charts 2
SUM based on existing context created by a measure 2
Row 2
Average from Matrix 2
Tip 2
Months between 2
syntax 2
Groups 2
date format 2
yoy 2
Quarter 2
normalize 2
Events in progress 2
date range 2
SUM of MAX 2
Substract with a measure 2
Moving average for measures 2
contract 2
guidelines 2
Please help 2
Gantt chart 2
benchmark 2
addcolumn 2
Rolling 12 Months 2
fiscal period 2
date hierarchy 2
DAX Performace 2
Workday 2
TREATAS 2
Model 2
Query Editor 2
combine 2
FIFO 2
Categories 2
Dynamic data selection based on date 2
COUNTA 2
conditional column 2
date filter 2
Reporting 2
calculated tables 2
Visuals 2
Python 2
Regression 2
Median 2
Managing Roles 2
Analysis 2
Stock Valuation 2
variance 2
Tutorial 2
sales 2
Concatenate columns in a measure 2
New quick measure 2
categorization 2
page filters 2
graphs 2
Age 2
Retention 2
ORDER 2
SVG 2
coalesce 2
Calculate function with multiple criteria 2
Calculated Measures Only 2
day 2
error 2
power bi visuals 2
segmentation 2
"aggregations" 2
30 2
Userrelationship 2
RankX excluding Some Values 2
Iterator 2
DAX Max Date within date range 2
previous week 2
Security roles 2
beginner 2
relations 2
Likert scale 2
Month on Month Rank Comparison 2
blanks 2
measures in calculated columns 2
evaluation context 2
Running totals and cumulatives 2
community 1
queries 1
Maximum number of values 1
date slicers 1
formating 1
stacked bar 1
Analytics 1
ALLCROSSFILTERED 1
Mean Time Between Failure 1
line chart visual 1
numbertostring 1
Nonlinear Regression 1
Production 1
debit 1
Premium Capacity 1
Work days 1
50 1
count of count 1
Denominator 1
expressions 1
stacked column chart 1
available time 1
List sorting 1
bell curve 1
POPL 1
DAX formula for tracking daily death cases 1
Merge files 1
multiple filters 1
Subtract 1
Case statement 1
NBA 1
For Loop 1
headcount when have FT and PT in department 1
comapring 1
Power M Query 1
FirstPass 1
PARALLELPERIOD 1
cumulative count with independent date tables 1
0 1
Rolling 6 months data 1
Advanced editor 1
Table Column 1
Education 1
User 1
data refresh 1
target 1
relative date filtering 1
multiple 1
two tables 1
Match 1
timeline report 1
active customers 1
financial report 1
F 1
simple 1
Access Control 1
result 1
tooltip 1
ee 1
To Show Ratio 1:2 1
resets if 0 1
Hierarchy of Slicers 1
Top5 with Other column 1
deadline 1
tMonth 1
overlaying graph 1
POP&L 1
Flag 1
Error of Expression Refers to multiple columns. Multiple columns cannot be converted to scalar value 1
Margin Percentage 1
Add "IF" before calculate 1
Empty 1
cardinality 1
Basket 1
running a Query with two tables to show each row 1
Split column 1
Dynamic slicer flag column 1
Reverse Cumulative 1
webpagelinking 1
not null 1
sum of measure 1
Previous Quarter 1
Expanded Tables 1
Need a help 1
heed help 1
Rolling AVG 1
Column Number 1
Custom Visual 1
Dynamic RLS 1
Scorecard 1
Memory 1
Grid 1
scheduled 1
metric 1
loop up values from 2 tables 1
last date time refresh 1
spend 1
Power BI report builder 1
MoM 1
Null 1
dataype 1
add value from prior row measure 1
new measure of % by group 1
expand 1
"Calculation Group" 1
ALLSELECT SURVIVAL RATE 1
HR 1
Day of Week 1
semi-additive 1
Year to date 1
Row Number in DAX 1
90 1
work load 1
customer concentration 1
chart axis with no data 1
@ Matrix Visualisation Error In Calculation 1
Combine Values 1
Tag rows 1
time format 1
Current Year VS Last Year 1
List value account 1
Help to Create Dax: applying filter for both Data Type(Text and Date) 1
TOTALMTD 1
dynamic field 1
DAX to Power M Query 1
weighted average 1
YYYY-YY 1
Needl Help 1
Roll 1
zero 1
hierarchy slicer merge text 1
Working Hours 1
l 1
BUG 1
parameter 1
Query String 1
default 1
node 1
conditions 1
Expertise help 1
funnel plots 1
weekdays 1
Lookupvalues 1
Help with DATESYTD DAX 1
transitive closure 1
in chosen periods 1
title 1
Please save me 1
Test as a Role 1
custom sorting 1
Help to update datasource 1
If Then 1
Turnover 1
Type 1
Group By For Two Columns in Dax 1
Window Function 1
NewBusiness 1
volume concentration 1
conditonal formatting 1
rowlevelsecurity 1
12 hour 1
true () 1
simulation 1
time-intelligence 1
record 1
DATESMTD() 1
change logs 1
hits 1
unique id 1
Past Due 1
COMBINEVALUE 1
Intersect() 1
hide blank 1
Timestamp 1
Data model 1
s 1
R 1
Premium 1
Scheduled data refresh 1
Live Connection 1
Visual Studio 1
running-totals 1
Like for like pricing analysis 1
Floriankx 1
Visualizations 1
changing classifications 1
product function 1
Currency 1
Object level security 1
selected value 1
Dynamics CRM 1
I'm losing my mind 1
EARLIEST 1
Market Share 1
Technical question 1
have 1
cumulative sum by multiple criteria 1
dyanmic 1
First Value 1
LostBusiness 1
concentration curve 1
Delimiters 1
perce 1
@stock_managment 1
one slicer to filter another table 1
24 hour 1
visual filter 1
Minimum AVG 1
isinscope 1
i need help 1
Parameter Data Type 1
month-to-date 1
DAV 1
related table 1
Time Range 1
unix 1
DATATABLE 1
cumulative distinct count 1
Missing Dates 1
Invoices 1
concatenate within SWITCH() 1
@help 1
Total Measure 1
"Help" 1
Design 1
correlation 1
Embed Report 1
weekly 1
axis 1
Format Date 1
wildcard 1
duplicate 1
many to many relationship issue 1
kcantor 1
pie chart tree 1
Unhandled 1
sql_to_dax 1
one row 1
total zero 1
DATESYTD Help needed 1
ONE TABLE MODEL 1
yield 1
Ordered Vs Delivered 1
Custom calendar 1
Multiplication and wrong total in table 1
filter direction 1
Analysis Server 1
Find multiple values 1
utilization 1
Past & Current Month Latest data 1
Operator 1
opening balance 1
ReturningBusiness 1
customer percentage vs sales percentage 1
Every 1
Variation 1
@inventory @DAX 1
relationship 1
change format 1
filter by date hierarchy 1
SCD2 1
Intersect 1
invoice 1
Navigation 1
Latest 1
Load Time 1
order time 1
summarize table 1
Difference Between Dates 1
Tabular Model 1
DAX Division with Date 1
@sumx 1
Point in time 1
monthlyaverage 1
data 1
timeline slicer 1
DAX FILTER 1
refresh data 1
pivot 1
Nee dhelp 1
iamprajot 1
where 1
automatic 1
Grouped field 1
by 1
SPC DAX XMR chart Control limits 1
correct visuals 1
mailchimp 1
Cound IDs 1
Replace Text Based on Another Column 1
Bundle 1
usage metrics report 1
facts filtering dimensions 1
Line and stacked column chart 1
Lowest Market Share 1
Productivity 1
su 1
daily difference 1
category 1
multiple join 1
Dynamic Ranking 1
ISNUMBER 1
change time format 1
revenue 1
DATEADD Visit Windows 1
Quarter Issue 1
Last N Months Data 1
Trend Line 1
STARTOFMONTH 1
attrition 1
sum duplicate dates 1
Load Graphs 1
Deaths 1
XIRR 1
Suma del promedio 1
amitchandak 1
help with matrix 1
Multiple columns 1
Management 1
imported 1
ovetteabejuela 1
Forex 1
New customers 1
Icon Formatting 1
Counter 1
comparison 1
count 0 and 1 1
Roleplaying 1
select all 1
DAX for deals added and slipped 1
calculate Percentile 1
Atingir Meta e Solver 1
Rebasing 1
Row Average 1
Column Chart 1
remote computers 1
Financial Year 1
able 1
Day on Day 1
Realtotals 1
new calculated table 1
consolidation 1
Dynamic Index 1
a da 1
times 1
country 1
actuals 1
exponent 1
PowerBIDesktop 1
busqueda rangos 1
KEEP 1
NoData 1
iteration 1
Disconnected tables 1
Resource Use 1
Previous row value 1
percentage of total column 1
unichar 1
DynamicMeasure 1
help with hiding subtotal 1
Scenario Analysis 1
Security 1
SharePoint 1
transpose 1
to 1
WOW 1
v-qiuyu-msft 1
inner join 1
Measure Multiplication 1
side by side 1
evaluate total for a period for a specific column 1
status change 1
delete rows 1
bad data 1
DAX com 1
like to get 1
fortnight 1
veryon 1
aaa 1
reference text 1
Top5 and Bottom 5 1
Week 1
Previous Month Last Year Card 1
compound 1
new calculated column 1
Report view 1
Average x month-13 1
display 1
filtrar 1
static value 1
ratio calculations dax 1
slicer calculation 1
rangos 1
Meausre 1
DAX Relationships 1
Rate of Production 1
- B 1
Calculate dates 1
Drilldown help 1
ISCROSSFILTERED 1
eryo 1
MAX Field ID 1
Questions 1
Embed 1
Map 1
Subscription 1
Active Directory 1
What If 1
text filter 1
Missing data 1
Combo Chart Report Server 1
row_number 1
last quarter 1
ThreeYear Average 1
Absolute Value 1
stage change 1
Need to mark holidays in calendar 1
fill empy cell 1
COVID-19 1
Text Measure 1
return 1
scenario 1
show statusRDP 1
@Ranks with Trend 1
color palette 1
returns 1
font colour 1
conditional format 1
Rolling inventory in each month associated with SKU 1
@countifs functionality @Need Helop 1
Maxdate 1
relative date slicer 1
@Greg_Deckler @Mich_J @amitchandak 1
weeks 1
help measure 1
Report Data 1
first per day 1
Sample 1
PowerQuery 1
worngvalues 1
Summing Measures 1
stock 1
dv 1
MULTIPLESELECTION 1
MIN date 1
running average 1
Azure 1
Dynamic Column 1
themes 1
Fiscal Year 1
counts 1
Region 1
sharepoint online 1
Sum on a dynamic date range 1
Company Average 1
LLY 1
opportunity stage 1
Cummulative Prev Change 1
Append measure to table 1
Match calculated ranking column 1
Circle diagram 1
Group total 1
TopN by Store 1
file name 1
BusinessCentral COA Totalling 1
remote desktop connection 1
Performance issues with AverageX 1
mailto 1
PRICE_NAME SUM(CALLS_SUM) AD 12 1
replace 1
hex 1
if and else 1
scalar 1
verting H 1
many to many 1
org chart 1
firstnonblank 1
filtro de tiempo 1
capacity 1
repurchase 1
Conteo 1
maxium 1
Advanced 1
interaction 1
dax problem 1
Total wrong 1
multiplication 1
match value 1
Thousand separator 1
smoothing 1
Weekday calculation 1
Excel 2016 1
Google Analytics 1
Roles 1
evaluation 1
drill through 1
Gantt 1
append 1
Power KPI Matrix 1
scatterplot 1
IFNA excel funation alternative 1
levels 1
Assigning Roles 1
Parameter formatting 1
Advanced Visualization 1
BI Vs Tableau 1
one inn many 1
Summarize() 1
"average" 1
Dynamic Flag 1
INCORRECT CALENDAR 1
Line & Stacked Column 1
CODE 1
column percent 1
context transition 1
dynamic percentage calculation 1
Alternatives for AverageX 1
have a 1
subject line 1
741 ADM 14 1
annual 1
DAX formulas for total quantity matching 1
with filters 1
filter context intersection 1
Table cell background color 1
"beginner asks Help" 1
Inventory 1
completed 1
isnonblank 1
hour 1
unico 1
Pareto Chart 1
dax calculations 1
Dinamyc index 1
IF THEN ELSE 1
rolling 12 month 1
overdue 1
number to text 1
estimation 1
Reverse Slicer 1
CONFIDENCE 1
API 1
Power BI Service 1
TopN Customer 1
Data Source 1
UserName 1
Power BI Data 1
Icons 1
% complete 1
churn 1
subgroups 1
not equal to 1
include 1
incorrect total 1
salary 1
10 1
Comcatenation 1
Filter two tables 1
ab 1
sclicer 1
Dinamic rows 1
Approximate Lookup Dates 1
totals calculation not correct in matrix 1
kpis 1
507 AE 990 AEDU 201 AEM 4 1
conditional replace 1
COUNTAX 1
hI i 1
Path 1
Monthly percentages 1
EarlierFunction 1
background color 1
Power BI Admin 1
quota 1
DAX table filter 1
new user 1
Transliteration 1
by count 1
max several rows 1
DatesMTD 1
non-zero 1
Score an account 1
ageing AP & AR 1
runningtotal 1
kernel 1
Open 1
Cohort Analysis 1
Salesforce 1
finance 1
database 1
key 1
PowerShell 1
PBI 1
Dynamics 365 1
quetsion 1
automation 1
sankey 1
FX 1
Margin 1
.DAX 1
Capital Gain 1
suggestions on Data Analysis 1
empty columns 1
testing 1
Replace Values Based on Another Column 1
CD and CSD 1
query folding 1
20 1
Selections 1
resource utilzation 1
growth rate 1
basket analysis 1
outbound delivery 1
395 AEMD 2 1
Weekly YOY 1
Parent 1
countblank 1
Bin 1
Conditional Formation Icons 1
Customer Revenue Comparison 1
Overlapping tables 1
Alias on summ 1
dax calculated 1
transform 1
by group 1
recruiting 1
@time 1
Fact 1
Future Dates 1
Previous YTD for Ranked Sales 1
Division 1
Multiple DAX switches and multiple slicers 1
large 1
Retension 1
Close and Backlog Tickets 1
Historic Table 1
survey 1
portfolio 1
RankX issue with RLS 1
Financial 1
Streaming Datasets 1
need 1
tooltips 1
Add Column 1
Video 1
Hierarchy slicer 1
Exchange 1
Share Valuation 1
" cumulatives" 1
dashboard dax help 1
change variables 1
pre 1
profit and loss 1
&& 1
ArcGIS Map 1
XLOOKUP 1
Error due to relationship 1
I need t 1
consecutive loss 1
Backlog 1
heed help on dax functions 1
not display data 1
297 AF 36 AFME 2 AFMO 13 AFMW 9 AG 5 AGM 33 AGMD 23 AIMD 3 AIMF 2 AK 35 AL 82 ALMA 218 ALME 56 ALMV 854 AM 10 AMGG 1 AMGU 2 1
Combination Table 1
Child 1
running 1
optimised 1
Non Calendar FY and FQ 1
Previous Week comparison 1
14 day 1
Overlap 1
math 1
Mongodb 1
Rowtotal 1
QTR 1
Duplicates 1
count of consecutive days 1
help fix 1
apply 1
leapyear 1
Week End Date Calculation 1
Filter using a measure 1
Tenure 1
Branching 1
DAX for Time Tracking 1
Historic Data 1
Pricing 1
Issue 1
Scheduling 1
numbers 1
CSV 1
Calendars 1
Cumulative sum partition 1
Stock In Hand 1
Transaction 1
maximum 1
credit 1
dependency 1
40 1
Nominator 1
Decomposition Tree 1
DAX CALENDARAUTO() 1
funnel 1
multiple dates 1
null value fields 1
Data Transformation 1
hide 1
HASONEFILTER 1
SEQUENCE 1
Unique Measure. 1
Button 1
sum vs target 1
working days 1
newbie 1
predictive models 1
VAT 1
Comparing columns 1
"LOOKUP" "DATA" "PERIOD" "INTERVAL" "BETWEEN" "SELECT" "FILTER" "TABLE" 1
@related @tables @relations 1
FPY 1
@ 1
SUMPRODUCT Measure 1
av 1
Outstanding 1
Store Data 1