Forum Discussion
How to get Power Bi to recognize and plot multiple data points in the same time frame
Ok, almost there!
Lastly, my data is a running data set, meaning I started tracking on June 15th. I understand that I can use the Slicer function to brake the data into months, is there a way to see the data set in its entirity, right now it looks like it is limited to 30 days.
Thanks for all the help, much appreciated!
CincyKidd
Eric- Thanks for the help, it looks like this might be the trick I was looking for, I will test it out later today and give a report.
By the way, I asked for the split instead of sum so I can look at specific performance. Now I will have the ability to look at combined performance or look at individual.
More to come and thanks again.
CincyKidd
Ok, two things.
1) what is the significance of the "Index" column?
2) how would I go about putting in the "Rank" column? I see there is code associated with the column.
Thanks.
CincyKidd
1) Index Column, give you starting to 0 or 1 a consecutive value to every row of your data table.
you can create this in Edit Query.
Creating an index starting to 0
2) Rank: this is the dax formula, its take in this case the index column and ranked in ascending. (1,2,3, etc)
Create a calculated column and put this:
Rank = RANKX(all('TableName');'TableName'[index];;ASC)
An you can create by this way:
New Column in the table and put this dax formula
Victor-
Could you explain step by step how to develop the "Index" column? I understand how to get into the "Query Editor", but I am lost past that.
Thanks for your help and patience.
CincyKidd
Figured out how to get the "index Column"!
Keeping on working the problem.
Thanks.
CincyKidd
