Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
I am trying to index a particular column based on re-occurance of same values (Region), can anyone please suggest solution for below
I have following data sample
Region Value
A 1000
B 500
C 2000
A 1000
D 2500
E 1500
I need solution as in following format
Region Value Regionoccurance
A 1000 1
B 500 1
C 2000 1
A 1000 2
D 2500 1
E 1500 1
Thanks in advance
Solved! Go to Solution.
@Viraj16Agate , refer to this video from Curbal, that can help. But in this you might need an index column first
https://www.youtube.com/watch?v=7CqXdSEN2k4
In dax
countx(filter(Table, [region] = earlier([region]) && [Index] <= earlier([Index]) ), [Index])
You need to create index in power query
@Viraj16Agate
You can first add an index column in Power Query or in the source then add the following column to your table in the model:
Column =
COUNTROWS(
FILTER( Table4 , Table4[Region] = EARLIER(Table4[Region]) && Table4[Value] = EARLIER(Table4[Value]) && Table4[Index] <= EARLIER(Table4[Index] ))
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Viraj16Agate , refer to this video from Curbal, that can help. But in this you might need an index column first
https://www.youtube.com/watch?v=7CqXdSEN2k4
In dax
countx(filter(Table, [region] = earlier([region]) && [Index] <= earlier([Index]) ), [Index])
You need to create index in power query
User | Count |
---|---|
42 | |
28 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |