Log In
Register
Home
Active Member
October 14, 2022
Offline
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
Offline
There is no attachment. Please try again and don't forget to press "Start upload" before you submit your reply.
Active Member
October 14, 2022
Offline
Mate I did upload and submit but it wouldnt show off the attachment what is issues in it
Trusted Members
Moderators
Power BI
January 31, 2022
Offline
Sorry, but I don't understand. There is no attachment and your question is not clear. At least not to me.
Active Member
October 14, 2022
Offline
find the file there is no best way to reach
Trusted Members
Moderators
Power BI
January 31, 2022
Offline
Thanks for the file and sorry for being slow. now you need to try and explain what you want to do with it.
Active Member
October 14, 2022
Offline
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
Offline
Sorry, but I don't understand. Perhaps someone else can help you.
October 17, 2018
Offline
You're explanation is probably clear for you but try to read it as someone that does not know what you're doing and then see for yourself if you understand it.
There is no logic for as far as I can see to group or log the data uder a number
1 Guest(s)
