Forum Discussion
Value changed in the same row for another column
Hi Group! (new here)
I have the next problem... I created a calendar table and now I want to make the equivalent to the fiscal date, so I added a column concatenating 3 columns to make the date, and look at what happened! For some dates, it changes the day that I am using, for example, day 31 in column "Date" in the last column appears as 1 (second row).
I really don't know why it happens, the issue is repeated in several cases all with the date 31.
#Valuechanged
#Newcolumndate
Thanks in advance!
you have two alternatives:
find the last day of each month, taking into account February
skip the day and define one by default in each month (e.g. 15). for tax dates no matter the day, the calculation is for the full month.
6 Replies
Syndicate_AdminAdministrator
you have two alternatives:
find the last day of each month, taking into account February
skip the day and define one by default in each month (e.g. 15). for tax dates no matter the day, the calculation is for the full month.
Thanksss!
- Syndicate_Admin
you should keep in mind that some months do not have 31 days. as in your case, June does not have it, you must validate that and change the day for 30.
in addition to taking into account February.
So true! I wasn't paying attention to the month! Thanks!
- amitchandak
Super User
EleAguero , Not very clear ,
Can you please explain?
refer
Creating Financial Calendar - From Any Month
https://community.powerbi.com/t5/Community-Blog/Creating-Financial-Calendar-Decoding-Date-and-Calendar-1-5-Power/ba-p/1187441Thanks for your answer! It is not necessary because the user below hit the nail on the head.
