GroupBy(
SortByColumns(
Filter(
MeterReadings,
readdate >= (DatePickerFrom_5.SelectedDate) && readdate <= DatePickerTo_5.SelectedDate && (StartsWith(
auth,
TextInput2.Text
) || StartsWith(
clientname,
TextInput2.Text
))
),
"auth"
),
auth,
Data
)
ShowColumns(
AddColumns(
AddColumns(
Filter(
colMRsbyWMA,
readdate >= DatePickerFrom_3.SelectedDate &&
readdate <= DatePickerTo_3.SelectedDate &&
StartsWith(
wma,
Dropdown2_1.Selected.Result
) &&
(
TextInput2.Text in auth ||
StartsWith(
clientname,
TextInput2.Text
)
)
),
Base,
If(
";" in auth,
First(
Split(
auth,
";"
)
).Value,
auth
)
),
mergedauths,
LookUp(
AddColumns(
GroupBy(
Ungroup(
AddColumns(
AddColumns(
colMRsbyWMA,
Auths,
Split(
auth,
";"
).Value
),
MainAuth,
First(Auths).Value
),
Auths
),
MainAuth,
Data
),
AllAuths,
Concat(
Distinct(
Data,
Value
),
Value,
";"
)
),
MainAuth = Base
).AllAuths
),
mergedauths,
readdate,
reading
)
GroupBy(
SortByColumns(
Filter(
colMRsbyWMA,
readdate >= DatePickerFrom_3.SelectedDate && readdate <= DatePickerTo_3.SelectedDate && StartsWith(
wma,
Dropdown2_1.Selected.Result
) && (TextInput2.Text in auth || StartsWith(
clientname,
TextInput2.Text
))
),
"auth"
),
auth,
Data
)
ShowColumns(
AddColumns(
AddColumns(
Table1,
Base,
If(
";" in auth,
First(
Split(
auth,
";"
)
).Value,
auth
)
),
mergedauths,
LookUp(
AddColumns(
GroupBy(
Ungroup(
AddColumns(
AddColumns(
Table1,
Auths,
Split(
auth,
";"
).Value
),
MainAuth,
First(Auths).Value
),
Auths
),
MainAuth,
Data
),
AllAuths,
Concat(
Distinct(
Data,
Value
),
Value,
";"
)
),
MainAuth = Base
).AllAuths
),
mergedauths,
readdate,
reading
)
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.