Forum Discussion

AG36912's avatar
AG36912
New Member
4 years ago
Solved

Finding deleted names based on date column

Hello Everyone,   I have a table with 2 columns: 1. Account names and 2. Date (date when the list when generated, ).   The list is generated every month and appended to a master file. I then fe...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
4 years ago

You are welcome.  Please show the expected result very clearly.

 

AG36912's avatar
AG36912
New Member
4 years ago

I'm trying to create a visualization wherein I can show a trendline for how many accounts got deleted every month. For eg (based on the sample quoted above): 1 acount ('C') got deleted in March and 1 account ('B') got deleted in April. I'm unable to drag this measure on the value field of the visualization.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    4 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.