Forum Discussion
Column mismatch between Desktop and Service
Hello, I'm relatively new to Power BI so hopefully this is something super easy and obvious to the more experienced. I have a basic report that contains a single line chart visual. The data sour...
- Hi there
What I would suggest doing is to rather create the new column in the Query Editor.
Then create a new column and add in the following code:
[ReportDate] + #duration(0,13,0,0)
GilbertQ Thanks for your reply. I'm still very much unaware of what the various use cases and merits are of power query vs DAX. There seems to a lot that can be done in both equally.
Anyway, because I want to format the date I did this:
DateTime.ToText( [ReportDate] + #duration(0,13,0,0),"dddd dd/MM"))
I wasn't sure whether I would be better adding the column in query editor like you describe and then adding another in the report to format the date, but I chose this way for now.
I've also changed the sort column to the ID of the SharePoint list item so the visual will always be in chronological order even if the date gets mucked up.
I'll find out tomorrow when the refresh happens if this has worked. Thanks again.
Hi there
Yeah I know it can be a challenge on where to decide where to do what.
I typically do all my data manipulation in Power Query because it is a lot easier. I have also found that it always works well and I do not have any weird things happening either.
Let us know if this works!
Yeah I know it can be a challenge on where to decide where to do what.
I typically do all my data manipulation in Power Query because it is a lot easier. I have also found that it always works well and I do not have any weird things happening either.
Let us know if this works!