Forum Discussion

Divya904's avatar
Divya904
Icon for Helper III rankHelper III
8 years ago

Remove timestamp from date

Hi Experts, I have created a date calendar using DAX as below:   Date = GENERATE ( CALENDARAUTO(), VAR currentDay = [Date] VAR day = DAY( currentDay ) VAR month = MONTH ( currentDay ) VAR ye...
Need Help
Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

I'm not sure sorry.  It's interesting that it works fine for me.  It suggests a setting in your Power BI Tenant such as region, or locale

Divya904's avatar
Divya904
Icon for Helper III rankHelper III
8 years ago

I know, date formats works differenctly in different machines. This is because of Power BI desktop regional settings and Browers settings for Power BI web service

I have set,

Power BI desktop , regional settings to English Australia

Web service setting is default Browser setting, which is English UK

System language and Locale setting is English Australia

 

Thanks.