Forum Discussion
Solved
Serial No. in visualisation
Hi, I have inserted a table in visualization in which columns are taken from different tables. I want a column in which serial no. comes
Hi IshaDahra,
Use below DAX
S.No =
RANKX(
SUMMARIZE(
ALLSELECTED('FACT_STORY'),
'FACT_STORY'[Number],
"MinUpdated", MIN('FACT_STORY'[Updated])
),
[MinUpdated],
,
ASC,
DENSE
)
S.No =
RANKX( SUMMARIZE( ALLSELECTED('FACT_STORY'), 'FACT_STORY'[Number], FACT_STORY[Updated]), CALCULATE(MIN(FACT_STORY[Updated]), ,ASC, DENSE )
)
Hi IshaDahra,
Use below DAX
S.No =
RANKX(
SUMMARIZE(
ALLSELECTED('FACT_STORY'),
'FACT_STORY'[Number],
"MinUpdated", MIN('FACT_STORY'[Updated])
),
[MinUpdated],
,
ASC,
DENSE
)