Forum Discussion
how can I insert fixed integer in series?
Hi, I am very new to Power BI, and have lots of questions.
Is it possible to insert fixed integer in series like {1..27} above red rectangle.
Either Quantity or Sales Amt would be sorted, the rank would be fixed.
I tried to make a new table with {1..27} and insert the column, but it looks like 27 same data of each line.
12 Replies
Do you want a fixed integer? or a Rank of a column?
oh! Thank you Vvelarde!
I want a fixed integer which is not changed by either Quanty rank or Sales Amt rank.
You can create A Rank
This is for Quantity
Rank=Rankx(all(NameTable);Calculate(Sum(NameTable[Quantity]));;Asc)
This is for Sales Amount
Rank=Rankx(all(NameTable);Calculate(Sum(NameTable[Sales Amount]));;Asc)
thank you so much Vvelarde!!
but this is not what I wanted, what I want is not Rank for each column (Qty, Amt), but 1 column of 1 ~ 27 fixed integer, regardless of Qty rank or Amt rank.
In Excel, it's just simple, but I don't know how to do it i Power BI.
