Forum Discussion
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...
Hi,
This measure works
Max date = if(format(MAX(Data[Date]),"mmyy")=FORMAT(today(),"mmyy"),BLANK(),EDATE(MAX(Data[Date]),1))Hope this helps.
Thanks much Ashish. I was able to create the new measure using your code but how do I project these counts (deleted accounts) on a PowerBI Visual month-on-month?
You are welcome. Please show the expected result very clearly.
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.