Forum Discussion

MikeFo's avatar
MikeFo
Frequent Visitor
3 years ago
Solved

Group by & Find/Replace?

Hi all   I have issues getting the right query for the scenario below. I appreciate it´s rather complicated to understand, but let me give it a try.   Table Name: Register   Credit Number C...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    MikeFo , Create a new column

    new Credit =
    Var _Eur = maxx(filter(Table, [Credit Number]=earlier( [Credit Number]) && [Currency]= "EUR"), [Credit])
    Var _USD = maxx(filter(Table, [Credit Number]=earlier( [Credit Number]) && [Currency]= "USD"), [Credit])
    Switch( True(),
    _Eur > _USD && [Currency] in {"EUR", "USD"}, 0,
    _Eur < _USD && [Currency] in {"USD"}, 0,
    [Credit])

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

MikeFo , Create a new column

new Credit =
Var _Eur = maxx(filter(Table, [Credit Number]=earlier( [Credit Number]) && [Currency]= "EUR"), [Credit])
Var _USD = maxx(filter(Table, [Credit Number]=earlier( [Credit Number]) && [Currency]= "USD"), [Credit])
Switch( True(),
_Eur > _USD && [Currency] in {"EUR", "USD"}, 0,
_Eur < _USD && [Currency] in {"USD"}, 0,
[Credit])

MikeFo's avatar
MikeFo
Frequent Visitor
3 years ago

Thanks, this helped. 

 

How would I apply this in the "Transform Data" view i.e. before the Close & Apply step?