add value of the first and last day of my table

[rodrigo09062015]

Hi,
I have a historical table that takes a picture of my database every day.
I need to take two measurements.
1. Create a measure to add a certain field, as long as the date is the first day of the month registered in the table.
2. Create the same measurement above for the last day of the month recorded in the table.

Suppose that for January the first day with record is January 2, 2022, it must take that date into account.

suppose the last day of registration is January 5th, 2022, it will be this date that he should consider.

[Icey]

Hi @rodrigo09062015 ,

Do you mean that you want to do something like below?

1. find the first and last day with record in current month;

2. filter data between the first and last day calculated in stpe 1;

3. screenshot

If so, could you share us more details? For example, some sample data and your desired result.

Reference: 

How to Get Your Question Answered Quickly - Microsoft Power BI Community

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rodrigo09062015]

Hi,
exactly.

follows link with fictitious data, but the way I have to treat my data

https://drive.google.com/file/d/1zIRVA99ejs2Svybx38a2-gSSiOUfwb0W/view?usp=sharing

[Icey]

Hi @rodrigo09062015 ,

Is this what you want?

DISTINCTCOUNT = 
VAR FirstDay_ =
    CALCULATE (
        MIN ( amostra[photo date] ),
        ALLEXCEPT ( amostra, amostra[período (month & year)] )
    )
RETURN
    CALCULATE ( DISTINCTCOUNT ( amostra[Status] ), amostra[photo date] = FirstDay_ )

COUNT = 
VAR FirstDay_ =
    CALCULATE (
        MIN ( amostra[photo date] ),
        ALLEXCEPT ( amostra, amostra[período (month & year)] )
    )
RETURN
    CALCULATE ( COUNT ( amostra[Status] ), amostra[photo date] = FirstDay_ )

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@rodrigo09062015 ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.

But these two blogs can help

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-o...