Forum Discussion
Problem with date
The date like 1/1/2021 could be received by
=DATE(C2,MONTH(A2&B2),A2)Didn't catch how that's linked to monthly dates column.
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.
UserExcel , 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.
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 ,,,,
- 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 ??
Like
A B C
Year Month Date
2 2021 3 3/3/2021
How do i get the date from only month and year like above ??