Forum Discussion
Amend Date Format in Live Connection to Remove Time Value
Hi, I'm using Alteryx to publish a dataset to the Power BI Service, which I'm then linking to in Power BI Desktop. When I do this I don't have the ability to amend the format of a field using the...
Anonymous
you need to make these changes with Alteryx when loading the data to the service. When you connect live you do not have the ability to makes changes tot the model
For those who also expereince this behavior I was proveded the below date to create a measure to propery format the date as requested from v-alq-msft,
reportdateMeasure = var _currentdate = MAX('Table'[report_date]) return MONTH(_currentdate)&"/"&DAY(_currentdate)&"/"&YEAR(_currentdate)