(Power Query Data) vs (Data Model Data)


#1

Hi All
Just wanted to know if anyone on here could please advise on this.

Question for all:
-In Power Query (Trade Volume Table) I’ve used Date.FromText to get my Trade Week Date in the right format of a date. When i close and refresh going into into Data Model my (Trade Week Date) is on the far right, and value fileld column has 0?
Really odd…
Any ideas as to why??

image


#2

Just checking on the back of this.
I did a quick COUNTROWS to make sure all rows have been loaded. This looks fine as the sum is 3,150.
Just curious regarding the column for “Trade Week Date”


#3

Could it be that the Value column is does not have a format of a number. Currently it looks like it has an unknown format of 123ABC. But it probably should be a number.

Try that


#4

No worries have solved it :slight_smile:
was just a big number, so the ordering was a little off. fine now

Sam just wondering
The Enterprise DNA Learning Summit May 2018., have all the videos been uploaded into the Portal?
In the below link I can only view 3 videos.

https://enterprisedna.lpages.co/enterprise-dna-learning-summit-may-2018-session-replays/?__s=wiec5du7jpkcuhh867qi

Shrik


#5

There is only 3 at moment. I have not been able to finish the last three due to illness, but still plan to very soon. I also need to place this up on the portal which I’ll also do when all are completed. Chrs


#6

No worries Sam thanks !
Do you know of any rough time/dates, estimates so I’m aware when I can start the full application on this?

Shrik


#7

No dates at the moment, I’m sorry.