Firstday of the MOnth

[Anonymous]

Hello,

Please help me with the DAX to get the first day of the month using the column in the DataSet with dates.

Attached DataSample.

https://drive.google.com/file/d/1KUafNwqRp9yWoHqpgA9dqQSZedWny6e0/view?usp=sharing

Regards,

[v-xicai]

Hi  @Anonymous ,

Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best regards

Amy

[v-xicai · Accepted solution]

Hi @Anonymous ,

You can create column like DAX below.

Column1= EOMONTH(Table1[Date],-1)+1

Best Regards,

Amy

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

[Anonymous]

Hi,

Please advise using Calcualted Column.

[Tahreem24]

HI @Anonymous ,

You can use FIRSTDATE(Table[DateColumn]) to get the first day of the month.

If this helpful so mark this a as solution! 

[thaker_pm]

Hi Tahreem, its not table, its measure, so firstdate won't work.