
Active Member

October 14, 2022

HI experts
I have data which is need validate count of repetation by splitting the group of Ledger ,how many times group of ledger got repeated
001 Ledger ID
Cash100000 | Active | All FAH Only Ledgers_100000 | Tier_1 |
OFSS-CB-AMER | Active | All FAH Only Ledgers_100000 | Tier_1 |
002 Ledger ID
Cash100000 | Active | All FAH Only Ledgers_100000 | Tier_1 |
OFSS-CB-AMER | Active | All FAH Only Ledgers_100000 | Tier_1 |
i want result.
for first time =1 for second time result =2,3,4....etc
find the attachment


Trusted Members
Moderators
Power BI

January 31, 2022



Trusted Members
Moderators
Power BI

January 31, 2022


Active Member

October 14, 2022

find the file there is no best way to reach


Trusted Members
Moderators
Power BI

January 31, 2022


Active Member

October 14, 2022

for e.g
Ledger Has ID NO
A B C D F F
X001 X3223|84848|Active|Onshore Result i want 1
X001 X3221|84838|Active|Onshore Result i want 1
X001 X10384|78376|Active|Onshore Result i want 1
three combination comes under different ledger id
X002 X3223|84848|Active|Onshore Result i want 2
X002 X3221|84838|Active|Onshore Result i want 2
X002 X10384|78376|Active|Onshore Result i want 2


Trusted Members
Moderators
Power BI

January 31, 2022

1 Guest(s)
