Watch videos with subtitles in your language, upload your videos, create your own subtitles! Click here to learn more on "how to Dotsub"

1-3d

0 (0 Likes / 0 Dislikes)
  • Embed Video

  • Embed normal player Copy to Clipboard
  • Embed a smaller player Copy to Clipboard
  • Advanced Embedding Options
  • Embed Video With Transcription

  • Embed with transcription beside video Copy to Clipboard
  • Embed with transcription below video Copy to Clipboard
  • Embed transcript

  • Embed transcript in:
    Copy to Clipboard
  • Invite a user to Dotsub
If you have date columns in your data, you can apply different transformations to help extract particular bits of information from that. For example, I've got date column here, but I might want to pull out the day of the week or the quarter that that date fell in. It's easy to do that with the Power BI query editor. On the transformation ribbon, you'll see a date option over here, and I've got a few different drop downs that show me the different pieces that I can extract. So, for example, the day of the week or the day of the year or just to extract the year piece or the first date of the year, the last date of the year, etc., etc. Now, when I'm working in the transform tab of the ribbon here, that means that I'm changing this column and I'm going to replace it with the piece that I choose. So I've replaced that date with just the year. If instead I wanted to add a new column with that information, I can choose this add column tab from the ribbon. And you'll see I have the same options. So let's just extract the year piece, and you'll see it adds a separate column into my query. So, for example, I might want to do the day of the week, so I get a zero based index note to six for which day it is, or I could choose the quarter. So sure enough, all of these dates in January are in the first quarter of the year. So there is a whole range of different options that you get here to extract certain information from your date/time fields. If I had time in here, I could do the same sort of thing for pulling out hours or minutes or seconds, and my duration one where I have options to combine things from minutes to hours or into seconds, etc., etc. A few different options for working with dates and times.

Video Details

Duration: 1 minute and 48 seconds
Country: United States
Language: English
License: All rights reserved
Genre: None
Views: 30
Posted by: csintl on Aug 15, 2016

I thought i had already uploaded these vids, so if any are duplicates, please don't re-translate. but do let me know either way. thanks. ----- (Please provide translations for these languages: Chinese (Simplified) (chi_hans), Chinese (Traditional) (chi_hant), English (eng), French (France) (fre_fr), German (ger), Italian (ita), Japanese (jpn), Korean (kor), Portuguese (Brazil) (por_br), Russian (rus), Spanish (spa).)

Caption and Translate

    Sign In/Register for Dotsub to translate this video.