Forum Discussion
Solved
add column based on another column
I've serarched for an answer to this but being new to Power BI i've really struggled to try find a solution I can translate to my own needs. I have a table with a list of ID's and date of entry: ...
Hi,
Try this calculated column formula
=CALCULATE(COUNTROWS(Data),FILTER(Data,Data[ID]=EARLIER(Data[ID])&&Data[Date Entered]<=EARLIER(Data[Date Entered])))
The result should be 1,1,2,3,2,4,1
Ashish_Mathur
Super User
Super UserHi,
Try this calculated column formula
=CALCULATE(COUNTROWS(Data),FILTER(Data,Data[ID]=EARLIER(Data[ID])&&Data[Date Entered]<=EARLIER(Data[Date Entered])))
The result should be 1,1,2,3,2,4,1
Thank you Ashish_Mathur that works perfectly :-)
- Ashish_Mathur
You are welcome.