Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

incremental column in Power BI

Hi Folks, I need small help. How to add incremental column in power bi, my source is tabular model i need add one column to display 1 to 50. Note: Without using Rank and without touching my model i ...
Need Help
Tips and Tricks
Tutorial Requests
v-yingjl's avatar
v-yingjl
Community Support
6 years ago

Hi Anonymous ,

Now let's arrange it together. Since your data source is a tabular model so that you cannot create a calculate column using Rankx(). Also, you don't want to modify your model. Right?

If so, whether I can create a measure intersperseding rankx() in it like this with the tabular model in power bi desktop to meet your requirement:

Measure =
VAR tab =
    SUMMARIZE (
        Sheet1,
        Sheet1[Provider Legacy Number],
        Sheet1[Paid Amount],
        "Rank", RANKX ( ALL ( Sheet1 ), Sheet1[Paid Amount] )
    )
RETURN
    SUMX ( tab, [Rank] )

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi still am getiing issue becacuse Sheet1[Paid Amount],  this is calucalted measure in model  while writing  measure am not able to get paidamount . In my report all columns are coming from different table.