Forum Discussion

SHKRV's avatar
SHKRV
Regular Visitor
5 years ago
Solved

Visualizing each distinct row by latest date

Hi,   I have a simple excel table with three processes. There are target dates for these process by which they need to be finalized. Every month I add new rows to the table and update the process. ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    SHKRV , Create a measure like this

    Measure = CALCULATE(COUNT('Table'[process]) ,FILTER(('Table'),'Table'[update Date] =CALCULATE(max('Table'[update Date]),ALLEXCEPT('Table','Table'[process]))))

     

    and use it with all non summarized columns

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

SHKRV , Create a measure like this

Measure = CALCULATE(COUNT('Table'[process]) ,FILTER(('Table'),'Table'[update Date] =CALCULATE(max('Table'[update Date]),ALLEXCEPT('Table','Table'[process]))))

 

and use it with all non summarized columns