First Entry of Each Month

[Anonymous]

Hi,

Is there a way to display the first date of entry for each month for each person?

I was able to find the very first entry of the year, but I want to somehow create a column that represents the first entry of each month, so I can use this column to find the number of days between the first entry of each month, and todays date

Currently, my formula to find the first entry is below:

Date of First Entry 2020 = calculate(firstnonblank(CP_Consolidated[2020 Dates],1),allexcept(CP_Consolidated,CP_Consolidated[Crew#]))

Thank you!
Sarah

[parry2k]

@Anonymous add this measure to get first entry of each month, assuming you have a date dimension in your model. As a best practice, add date dimension in your model and use it for and time intelligence calculations. Once the date dimension is added, mark it as a date table on table tools.

https://perytus.com/2020/05/22/create-a-basic-date-table-in-your-data-model-for-time-intelligence-calculations/

First Entry Measure = CALCULATE( FIRSTNONBLANK( 'Calendar'[Date] , 1), CP_Consolidated )

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

[amitchandak]

@Anonymous , you need have month year column,

view this my month -year

FIRSTNONBLANKVALUE(CP_Consolidated[Crew#],Max(CP_Consolidated[2020 Dates]))

or

FIRSTNONBLANKVALUE(CP_Consolidated[month-year],FIRSTNONBLANKVALUE(CP_Consolidated[Crew#],Max(CP_Consolidated[2020 Dates])))

[Anonymous · Accepted solution]

@amitchandak 

So this correctly finds the first day of the full year, but is there a way to find the first date for each month? so when it becomes February, instead of "1/2/2020", the correct output would be "2/3/2020"?

Thank you!
Sarah