- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- « Previous
- Next »
Re: Custom column Index or Ranking by other column
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
02-24-2018 07:56 AM
You are a genious!!! Saved lots of time . Thanks for the soultion
Re: Custom column Index or Ranking by other column
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
04-17-2018 01:56 AM
Hi. I'm trying to do something different about the cases exposed.
I have a table that need an increase index when I have some change between three columns. I mean:
Worker | Fecha | Valor | Index |
A | 16/04/2018 | TRUE | 1 |
A | 16/04/2018 | TRUE | 1 |
A | 16/04/2018 | FALSE | 2 |
A | 16/04/2018 | TRUE | 3 |
B | 15/04/2018 | TRUE | 4 |
B | 16/04/2018 | FALSE | 5 |
B | 16/04/2018 | TRUE | 6 |
B | 16/04/2018 | TRUE | 6 |
Starting by 1 in each change of first 3 columns I need to increase the index. I'm trying with all the answer from this post but I can't find the solution.
Other possibility is to save the last combination and the last index in a parameter or another table, but I can't find how to save it in a parameter or table.
Re: Custom column Index or Ranking by other column
[ Edited ]- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
04-17-2018 01:58 AM - edited 04-17-2018 03:32 AM
Hi. I'm trying to do something different about the cases exposed.
I have a table that need an increase index when I have some change between three columns. I mean:
Worker | Fecha | Valor | Index |
A | 16/04/2018 | TRUE | 1 |
A | 16/04/2018 | TRUE | 1 |
A | 16/04/2018 | FALSE | 2 |
A | 16/04/2018 | TRUE | 3 |
B | 15/04/2018 | TRUE | 4 |
B | 16/04/2018 | FALSE | 5 |
B | 16/04/2018 | TRUE | 6 |
B | 16/04/2018 | TRUE | 6 |
Starting by 1 in each change of first 3 columns I need to increase the index. I'm trying with all the answer from this post but I can't find the solution.
Other possibility is to save the last combination and the last index in a parameter or another table, but I can't find how to save it in a parameter or table.
In Excel is very easy because yo can calculate from the information in the last cell, but here I can't.
The excel formula could be:
=SI(A2=A1;SI(C2="FALSE";SI(C1="FALSE";E1;E1+1);SI(C1="FALSE";E1+1;E1));E1+1)
Re: Custom column Index or Ranking by other column
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
04-17-2018 10:28 PM
Yes, that's possible. No use for the grouping in this case, as your index shall continue to run. The only thing you need here is a reference to your previous row. For performance reasons, I recommend this method:
https://www.youtube.com/watch?v=xN2IRXQ2CvI
Did I answer your question? Mark my post as a solution!
Proud to be a Datanaut!
Imke Feldmann
How to integrate M-code into your solution -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Re: Custom column Index or Ranking by other column
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
06-10-2018 06:43 PM
saving this jewel to favorites!
- « Previous
- Next »