Need Month 1st date value in each row

Hi, shanipowerbi 

Please try the below measure.

sales first day of month =
VAR currentyear =
YEAR ( MAX ( Sales[Date] ) )
VAR currentmonth =
MONTH ( MAX ( Sales[Date] ) )
VAR currentmonthfirstday =
DATE ( currentyear, currentmonth, 1 )
RETURN
CALCULATE ( Sales[sales], Sales[Date] = currentmonthfirstday )

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/

Hi, shanipowerbi 

I am not sure how you changed the context, but if it is OK with you, please share your sample pbix file's link, then I can try to look into it to come up with a more accurate measure.

Thank you.

Hi,

please share your sample pbix file's link, then I can try to look into it.

Thank you.