Forum Discussion
Transform/ Change Date value
Hi gurus, I have my Power BI desktop connected to an ERP database. As part of the data feed, I have a Date column that has a default value of TODAY's date in mm/dd/yyyy format. I need to change...
amitchandak
Super User
Super UserAnonymous , In the new column you can create like
Date 1= eomonth([date],-1) +1
Or
Date 1= date(Year([date]), Month([date]), 01)