Forum Discussion

Shanvitha_V's avatar
Shanvitha_V
Frequent Visitor
3 years ago
Solved

Based on Slicer selection Rank(squency)

Hi Export, I have date Range slicer and Month_year,Value columns there in table  I need table format should be like S.No,Month_year,Value in table S.No i need create new column/Measure S.No sho...
  • amitchandak's avatar
    3 years ago

    Shanvitha_V , Assume date is used in visual

     

    calculate(distinctcount(Table[Date]) , filter(allselected(Table), Table[Date] <= max(table[Date])) )