Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
Please help. For some reason, my date switch month and year every 13th of each month and back again at the begining of month.
correct month=If ([Month]<12,[Day],[Month])
This does not work and only shows [Day] column in new correct month column. Could you please help!
All the best,
Paris
Solved! Go to Solution.
hi @paris
Just try this simple formula
CorrectDay = IF([Day]>12,[Day],[Month])
CorrectMonth = IF([Day]>12,[Month],[Day])
Result:
Regards,
Lin
Could you please show the expected result in the excel?
newmonth = if('Table'[day]<=12,'Table'[day],if(mod('Table'[day],12)=0,12,mod('Table'[day],12)))
I am not sure if I understand your request clearly.
Proud to be a Super User!
Hi Ryan
Thank you for your response. I am sorry my question was not clear.
Date here is in text format and when I tried to use day and month formular I get wrong data from 1st till 12th of each month.
I like to correct it by creating new column and want to get answer in yellow.
All the best,
Paris
hi @paris
Just try this simple formula
CorrectDay = IF([Day]>12,[Day],[Month])
CorrectMonth = IF([Day]>12,[Month],[Day])
Result:
Regards,
Lin
Hi Lin
Thank you so much for your help!
All the best,
Paris
@paris , what is expected output
Hallo Amitchandak,
I am sorry I was not clear.
Date is in text format. When I used formular to get day and month, I got them wrong so I want to correct like yellow here.
All the best,
Paris
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |