Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all, I am looking for a way to replace static table/column names with variables. I have several tables to create based on the following
Amortization PS =
SUMMARIZE(filter(CROSSJOIN(AOPF,'Date'),'Date'[Date]>=(AOPF[Project Start Date]) && 'Date'[Date]<=(AOPF[Consulting/PS Amortization End Date])),
[Year-Month],[Date],[Project Title],
"CapEx Daily",Max(AOPF[Consulting/PS CapEx])/(DATEDIFF(Min(AOPF[Project Start Date]),Max(AOPF[Consulting/PS Amortization End Date]),DAY)+1),
"OpEx Daily",MAX(AOPF[Consulting/PS OpEx])/(DATEDIFF(Min(AOPF[Project Start Date]),
Max(AOPF[Consulting/PS Amortization End Date]),DAY)+1))
What I am trying to do is replace items such as “Consulting/PS Amortization End Date” with a variable. Such as
VAR AmEndDate = Consulting/PS Amortization End Date
or
(AOPF[Consulting/PS Amortization End Date])
Nothing I try seems to work unless I use a function but that does not resolve my issue.
Any help would be appreciated
Solved! Go to Solution.
@marcmen ,
Like this ?
Amortization PS =
var _col = AOPF[Consulting/PS Amortization End Date]
return
SUMMARIZE(filter(CROSSJOIN(AOPF,'Date'),'Date'[Date]>=(AOPF[Project Start Date]) && 'Date'[Date]<=(_col)),
[Year-Month],[Date],[Project Title],
"CapEx Daily",Max(AOPF[Consulting/PS CapEx])/(DATEDIFF(Min(AOPF[Project Start Date]),Max(AOPF[Consulting/PS Amortization End Date]),DAY)+1),
"OpEx Daily",MAX(AOPF[Consulting/PS OpEx])/(DATEDIFF(Min(AOPF[Project Start Date]),
Max(AOPF[Consulting/PS Amortization End Date]),DAY)+1))
if variable means selectedvalue in the slicer. Then it will not work , new table or column do not take slicer value
@marcmen ,
Like this ?
Amortization PS =
var _col = AOPF[Consulting/PS Amortization End Date]
return
SUMMARIZE(filter(CROSSJOIN(AOPF,'Date'),'Date'[Date]>=(AOPF[Project Start Date]) && 'Date'[Date]<=(_col)),
[Year-Month],[Date],[Project Title],
"CapEx Daily",Max(AOPF[Consulting/PS CapEx])/(DATEDIFF(Min(AOPF[Project Start Date]),Max(AOPF[Consulting/PS Amortization End Date]),DAY)+1),
"OpEx Daily",MAX(AOPF[Consulting/PS OpEx])/(DATEDIFF(Min(AOPF[Project Start Date]),
Max(AOPF[Consulting/PS Amortization End Date]),DAY)+1))
if variable means selectedvalue in the slicer. Then it will not work , new table or column do not take slicer value
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
105 | |
78 | |
67 | |
63 |
User | Count |
---|---|
148 | |
107 | |
106 | |
83 | |
70 |