Problem with date

Question

sergeibaklan · Answer

UserExcel&nbsp;
The date like 1/1/2021 could be received by
=DATE(C2,MONTH(A2&amp;B2),A2)
Didn't catch how that's linked to monthly dates column.

userexcel · Answer

Thank you Sergei !! It worked !!!! I just needed to create a arbitrary date keeping the month and year same ,, Its for the purpose to use time intelligence function in power bi.

sergeibaklan · Answer

UserExcel&nbsp;, glad it helped
As a comment, usual practice now is to use EOMONTH instead of MonthKey in Date / Calendar table, not first of month. But that's up to you.

userexcel · Answer

Thank you Serge, I have only month and year in my data so I need only date which was missing to use time intelligence ,, my boss is concerned with the monthly and quarterly visual report,, not in daily basis ,,,,

userexcel · Answer

Hi Sergie ,, I have the value of 3 as a month number and 2021 as a year ,, I would like to get a 3/3/2021,, Can you help me ??LikeA B CYear Month Date2 2021 3 3/3/2021How do i get the date from only month and year like above ??

Forum Discussion

Problem with date

7 Replies

Resources