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: ...
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.

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.