Forum Discussion
Anonymous
6 years agoNot applicable
Data Showing in Incorrect Month?
Hi All, I have imported the PowerBi table that was links to an excel file into a sharepoint list to create a better user experience. However my charts are not out by one month... I get t...
amitchandak
6 years agoSuper User
Anonymous , Not very clear, Can you share sample data and sample output.
Your date that is joining with date table may have timestamp. In that case remove timestamp
New DATE =[timestamp].date
or
New DATE =date(year([timestamp]),month([timestamp]),day([timestamp]))