Forum Discussion

irshadanwar09's avatar
irshadanwar09
New Member
3 years ago
Solved

Extract Value

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 .

Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    3 years ago

    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.

4 Replies

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support
    3 years ago

    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.

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    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.

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support
    3 years ago

    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.