Extract Value

[irshadanwar09]

You have a CSV File that contains user complaints. The File contains a column named Logged. Logged contains the date and time each compliant

occurred. The data in Logged is in the following format: 2018-12-31 at 08:59.

You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy.

What should you do?

A. Apply a transform to extract first 11 characters of the logged column.

B.  Create colum by example that start with 2018-12-31 and set the data type to new column to date .

[ShreyaPowerBI]

A is correct since the requirement is to create a data hierarchy 

[v-yalanwu-msft · Accepted solution]

Hi, @irshadanwar09 ;

Is your problem solved?  If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yalanwu-msft]

Hi, @irshadanwar09 ;

If I understand correctly，I will split the column.

The final show:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@irshadanwar09 , In Power Query a new column

Date = DateTime.Date([Date Logged])

in Dax

Date = Datevalue([Date Logged])

And use that column. Prefer to use date table joined to this date with all required columns 

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.