About mmustafaaslan

I have always had a strong interest in Coding, Thus I am an expert user of Microsoft Office (especially Microsoft Excel) and Office Applications and database designing and a lot more besides.
1 02, 2019

Power Query – Simülasyon Yapıcak Fonksiyon Oluşturma

By |2019-02-01T15:39:39+00:00Şubat 1st, 2019|Categories: Genel, M - Power Query - Sorgu Dili, Power Query - Table Fonsiyonları, Power Query – List Fonsiyonları|Tags: , , , , , , , |Yorum yok

[fusion_builder_container hundred_percent="no" hundred_percent_height="no" hundred_percent_height_scroll="no" hundred_percent_height_center_content="yes" equal_height_columns="no" menu_anchor="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" status="published" publish_date="" class="" id="" background_color="" background_image="" background_position="center center" background_repeat="no-repeat" fade="no" background_parallax="none" enable_mobile="no" parallax_speed="0.3" video_mp4="" video_webm="" video_ogv="" video_url="" video_aspect_ratio="16:9" video_loop="yes" video_mute="yes" video_preview_image="" border_size="" border_color="" border_style="solid" margin_top="" margin_bottom="" padding_top="" padding_right="" padding_bottom="" padding_left=""][fusion_builder_row][fusion_builder_column type="1_1" layout="1_1" spacing="" center_content="no" link="" target="_self" min_height="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" class="" id="" background_color="" background_image="" background_image_id="" background_position="left top" background_repeat="no-repeat" hover_type="none" border_size="0" border_color="" border_style="solid" border_position="all" padding_top="" padding_right="" padding_bottom="" padding_left="" margin_top="" margin_bottom="" animation_type="" animation_direction="left" animation_speed="0.3" animation_offset="" last="no"][fusion_youtube id="https://www.youtube.com/watch?v=vsZo4OdXoJ4" alignment="center" width="1080" height="760" autoplay="true" api_params=" &rel=0" hide_on_mobile="small-visibility,medium-visibility,large-visibility" class="" css_id="" /][fusion_separator style_type="single solid" hide_on_mobile="small-visibility,medium-visibility,large-visibility" class="" id="" sep_color="" top_margin="10" bottom_margin="10" border_size="" icon="" icon_circle="" icon_circle_color="" width="" alignment="center" /][/fusion_builder_column][fusion_builder_column type="1_4" layout="1_4" spacing="" center_content="no"

31 01, 2019

Kaynak Dosya İsmini Tutmak veya Tablo İçerisine Eklemek

By |2019-01-31T15:58:22+00:00Ocak 31st, 2019|Categories: Genel, M - Power Query - Sorgu Dili, Power Query - Table Fonsiyonları, Power Query – List Fonsiyonları|Tags: , , , , , |Yorum yok

[fusion_builder_container hundred_percent="no" hundred_percent_height="no" hundred_percent_height_scroll="no" hundred_percent_height_center_content="yes" equal_height_columns="no" menu_anchor="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" status="published" publish_date="" class="" id="" background_color="" background_image="" background_position="center center" background_repeat="no-repeat" fade="no" background_parallax="none" enable_mobile="no" parallax_speed="0.3" video_mp4="" video_webm="" video_ogv="" video_url="" video_aspect_ratio="16:9" video_loop="yes" video_mute="yes" video_preview_image="" border_size="" border_color="" border_style="solid" margin_top="" margin_bottom="" padding_top="" padding_right="" padding_bottom="" padding_left=""][fusion_builder_row][fusion_builder_column type="1_1" layout="1_1" spacing="" center_content="no" link="" target="_self" min_height="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" class="" id="" background_color="" background_image="" background_image_id="" background_position="left top" background_repeat="no-repeat" hover_type="none" border_size="0" border_color="" border_style="solid" border_position="all" padding_top="" padding_right="" padding_bottom="" padding_left="" margin_top="" margin_bottom="" animation_type="" animation_direction="left" animation_speed="0.3" animation_offset="" last="no"][fusion_youtube id="https://www.youtube.com/watch?v=WQ0ARze1vy0" alignment="center" width="1080" height="760" autoplay="true" api_params=" &rel=0" hide_on_mobile="small-visibility,medium-visibility,large-visibility" class="" css_id="" /][fusion_separator style_type="single solid" hide_on_mobile="small-visibility,medium-visibility,large-visibility" class="" id="" sep_color="" top_margin="10" bottom_margin="10" border_size="" icon="" icon_circle="" icon_circle_color="" width="" alignment="center" /][/fusion_builder_column][fusion_builder_column type="1_4" layout="1_4" spacing="" center_content="no"

31 01, 2019

Power Query – Aradaki Boşlukların Silinmesi

By |2019-01-31T12:08:05+00:00Ocak 31st, 2019|Categories: Genel, M - Power Query - Sorgu Dili, Power Query - Table Fonsiyonları, Power Query – List Fonsiyonları|Tags: , , , , , , , , |Yorum yok

[fusion_builder_container hundred_percent="no" hundred_percent_height="no" hundred_percent_height_scroll="no" hundred_percent_height_center_content="yes" equal_height_columns="no" menu_anchor="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" status="published" publish_date="" class="" id="" background_color="" background_image="" background_position="center center" background_repeat="no-repeat" fade="no" background_parallax="none" enable_mobile="no" parallax_speed="0.3" video_mp4="" video_webm="" video_ogv="" video_url="" video_aspect_ratio="16:9" video_loop="yes" video_mute="yes" video_preview_image="" border_size="" border_color="" border_style="solid" margin_top="" margin_bottom="" padding_top="" padding_right="" padding_bottom="" padding_left=""][fusion_builder_row][fusion_builder_column type="1_1" layout="1_1" spacing="" center_content="no" link="" target="_self" min_height="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" class="" id="" background_color="" background_image="" background_image_id="" background_position="left top" background_repeat="no-repeat" hover_type="none" border_size="0" border_color="" border_style="solid" border_position="all" padding_top="" padding_right="" padding_bottom="" padding_left="" margin_top="" margin_bottom="" animation_type="" animation_direction="left" animation_speed="0.3" animation_offset="" last="no"][fusion_youtube id="https://www.youtube.com/watch?v=9Nriwe955Zo" alignment="center" width="1080" height="760" autoplay="true" api_params=" &rel=0" hide_on_mobile="small-visibility,medium-visibility,large-visibility" class="" css_id="" /][fusion_separator style_type="single solid" hide_on_mobile="small-visibility,medium-visibility,large-visibility" class="" id="" sep_color="" top_margin="10" bottom_margin="10" border_size="" icon="" icon_circle="" icon_circle_color="" width="" alignment="center" /][/fusion_builder_column][fusion_builder_column type="1_4" layout="1_4" spacing="" center_content="no"

30 01, 2019

Power Query – Tüm Sütun Adlarını Değiştirme

By |2019-01-30T14:32:12+00:00Ocak 30th, 2019|Categories: Genel, M - Power Query - Sorgu Dili, Power Query - Table Fonsiyonları, Power Query – List Fonsiyonları|Tags: , , , , , , |Yorum yok

[fusion_builder_container hundred_percent="no" hundred_percent_height="no" hundred_percent_height_scroll="no" hundred_percent_height_center_content="yes" equal_height_columns="no" menu_anchor="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" status="published" publish_date="" class="" id="" background_color="" background_image="" background_position="center center" background_repeat="no-repeat" fade="no" background_parallax="none" enable_mobile="no" parallax_speed="0.3" video_mp4="" video_webm="" video_ogv="" video_url="" video_aspect_ratio="16:9" video_loop="yes" video_mute="yes" video_preview_image="" border_size="" border_color="" border_style="solid" margin_top="" margin_bottom="" padding_top="" padding_right="" padding_bottom="" padding_left=""][fusion_builder_row][fusion_builder_column type="1_1" layout="1_1" spacing="" center_content="no" link="" target="_self" min_height="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" class="" id="" background_color="" background_image="" background_image_id="" background_position="left top" background_repeat="no-repeat" hover_type="none" border_size="0" border_color="" border_style="solid" border_position="all" padding_top="" padding_right="" padding_bottom="" padding_left="" margin_top="" margin_bottom="" animation_type="" animation_direction="left" animation_speed="0.3" animation_offset="" last="no"][fusion_youtube id="https://www.youtube.com/watch?v=Q6rb2f2zup8" alignment="center" width="1080" height="760" autoplay="true" api_params=" &rel=0" hide_on_mobile="small-visibility,medium-visibility,large-visibility" class="" css_id="" /][fusion_separator style_type="single solid" hide_on_mobile="small-visibility,medium-visibility,large-visibility" class="" id="" sep_color="" top_margin="10" bottom_margin="10" border_size="" icon="" icon_circle="" icon_circle_color="" width="" alignment="center" /][/fusion_builder_column][fusion_builder_column type="1_4" layout="1_4" spacing="" center_content="no"

29 01, 2019

Fonksiyonun birden fazla sütuna aynı anda uygulanması

By |2019-01-29T15:48:49+00:00Ocak 29th, 2019|Categories: Genel, M - Power Query - Sorgu Dili|Tags: , , , , |Yorum yok

[fusion_builder_container hundred_percent="no" hundred_percent_height="no" hundred_percent_height_scroll="no" hundred_percent_height_center_content="yes" equal_height_columns="no" menu_anchor="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" status="published" publish_date="" class="" id="" background_color="" background_image="" background_position="center center" background_repeat="no-repeat" fade="no" background_parallax="none" enable_mobile="no" parallax_speed="0.3" video_mp4="" video_webm="" video_ogv="" video_url="" video_aspect_ratio="16:9" video_loop="yes" video_mute="yes" video_preview_image="" border_size="" border_color="" border_style="solid" margin_top="" margin_bottom="" padding_top="" padding_right="" padding_bottom="" padding_left=""][fusion_builder_row][fusion_builder_column type="1_1" layout="1_1" spacing="" center_content="no" link="" target="_self" min_height="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" class="" id="" background_color="" background_image="" background_image_id="" background_position="left top" background_repeat="no-repeat" hover_type="none" border_size="0" border_color="" border_style="solid" border_position="all" padding_top="" padding_right="" padding_bottom="" padding_left="" margin_top="" margin_bottom="" animation_type="" animation_direction="left" animation_speed="0.3" animation_offset="" last="no"][fusion_youtube id="https://www.youtube.com/watch?v=smR3SDIOSRI" alignment="center" width="1080" height="760" autoplay="true" api_params=" &rel=0" hide_on_mobile="small-visibility,medium-visibility,large-visibility" class="" css_id="" /][fusion_separator style_type="single solid" hide_on_mobile="small-visibility,medium-visibility,large-visibility" class="" id="" sep_color="" top_margin="10" bottom_margin="10" border_size="" icon="" icon_circle="" icon_circle_color="" width="" alignment="center" /][/fusion_builder_column][fusion_builder_column type="1_4" layout="1_4" spacing="" center_content="no"

28 01, 2019

Power Query ile Basamaklı Fonksiyon Oluşturma

By |2019-01-29T10:24:10+00:00Ocak 28th, 2019|Categories: Genel, M - Power Query - Sorgu Dili|Tags: , , , , , |Yorum yok

[fusion_builder_container hundred_percent="no" hundred_percent_height="no" hundred_percent_height_scroll="no" hundred_percent_height_center_content="yes" equal_height_columns="no" menu_anchor="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" status="published" publish_date="" class="" id="" background_color="" background_image="" background_position="center center" background_repeat="no-repeat" fade="no" background_parallax="none" enable_mobile="no" parallax_speed="0.3" video_mp4="" video_webm="" video_ogv="" video_url="" video_aspect_ratio="16:9" video_loop="yes" video_mute="yes" video_preview_image="" border_size="" border_color="" border_style="solid" margin_top="" margin_bottom="" padding_top="" padding_right="" padding_bottom="" padding_left=""][fusion_builder_row][fusion_builder_column type="1_1" layout="1_1" spacing="" center_content="no" link="" target="_self" min_height="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" class="" id="" background_color="" background_image="" background_image_id="" background_position="left top" background_repeat="no-repeat" hover_type="none" border_size="0" border_color="" border_style="solid" border_position="all" padding_top="" padding_right="" padding_bottom="" padding_left="" margin_top="" margin_bottom="" animation_type="" animation_direction="left" animation_speed="0.3" animation_offset="" last="no"][fusion_youtube id="https://www.youtube.com/watch?v=YC8zD_Ui1oo" alignment="center" width="1080" height="760" autoplay="true" api_params=" &rel=0" hide_on_mobile="small-visibility,medium-visibility,large-visibility" class="" css_id="" /][fusion_separator style_type="single solid" hide_on_mobile="small-visibility,medium-visibility,large-visibility" class="" id="" sep_color="" top_margin="10" bottom_margin="10" border_size="" icon="" icon_circle="" icon_circle_color="" width="" alignment="center" /][/fusion_builder_column][fusion_builder_column type="1_4" layout="1_4" spacing="" center_content="no"

28 01, 2019

Power Query ile Fonksiyon Oluşturma

By |2019-01-29T10:26:15+00:00Ocak 28th, 2019|Categories: M - Power Query - Sorgu Dili|Tags: , , , , |Yorum yok

[fusion_builder_container hundred_percent="no" hundred_percent_height="no" hundred_percent_height_scroll="no" hundred_percent_height_center_content="yes" equal_height_columns="no" menu_anchor="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" status="published" publish_date="" class="" id="" background_color="" background_image="" background_position="center center" background_repeat="no-repeat" fade="no" background_parallax="none" enable_mobile="no" parallax_speed="0.3" video_mp4="" video_webm="" video_ogv="" video_url="" video_aspect_ratio="16:9" video_loop="yes" video_mute="yes" video_preview_image="" border_size="" border_color="" border_style="solid" margin_top="" margin_bottom="" padding_top="" padding_right="" padding_bottom="" padding_left=""][fusion_builder_row][fusion_builder_column type="1_1" layout="1_1" spacing="" center_content="no" link="" target="_self" min_height="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" class="" id="" background_color="" background_image="" background_image_id="" background_position="left top" background_repeat="no-repeat" hover_type="none" border_size="0" border_color="" border_style="solid" border_position="all" padding_top="" padding_right="" padding_bottom="" padding_left="" margin_top="" margin_bottom="" animation_type="" animation_direction="left" animation_speed="0.3" animation_offset="" last="no"][fusion_youtube id="https://www.youtube.com/watch?v=FZ8Ai8s_ejg" alignment="center" width="1080" height="760" autoplay="true" api_params=" &rel=0" hide_on_mobile="small-visibility,medium-visibility,large-visibility" class="" css_id="" /][/fusion_builder_column][fusion_builder_column type="1_4" spacing="" center_content="no" link="" target="_self" min_height="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" class="" id="" background_color="" background_image="" background_image_id="" background_position="left top" background_repeat="no-repeat" hover_type="none" border_size="0" border_color="" border_style="solid"

24 01, 2019

Satırları Birleştirme – Table.Column / List.FirstN / Table.FirstN

By |2019-01-29T10:26:36+00:00Ocak 24th, 2019|Categories: Genel, M - Power Query - Sorgu Dili, Power Query - Table Fonsiyonları, Power Query – List Fonsiyonları|Tags: , , , , |Yorum yok

[fusion_builder_container hundred_percent="no" equal_height_columns="no" menu_anchor="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" class="" id="" background_color="" background_image="" background_position="center center" background_repeat="no-repeat" fade="no" background_parallax="none" parallax_speed="0.3" video_mp4="" video_webm="" video_ogv="" video_url="" video_aspect_ratio="16:9" video_loop="yes" video_mute="yes" overlay_color="" video_preview_image="" border_size="" border_color="" border_style="solid" padding_top="" padding_bottom="" padding_left="" padding_right=""][fusion_builder_row][fusion_builder_column type="1_1" layout="1_1" background_position="left top" background_color="" border_size="" border_color="" border_style="solid" border_position="all" spacing="yes" background_image="" background_repeat="no-repeat" padding_top="" padding_right="" padding_bottom="" padding_left="" margin_top="0px" margin_bottom="0px" class="" id="" animation_type="" animation_speed="0.3" animation_direction="left" hide_on_mobile="small-visibility,medium-visibility,large-visibility" center_content="no" last="no" min_height="" hover_type="none" link=""][fusion_youtube id="https://www.youtube.com/watch?v=g5iz3Zcz6k0" alignment="center" width="1080" height="810" autoplay="true" api_params="&rel=0" hide_on_mobile="small-visibility,medium-visibility,large-visibility" class="" css_id="" /][fusion_separator style_type="double solid" hide_on_mobile="small-visibility,medium-visibility,large-visibility" class="" id="" sep_color="#ffc107" top_margin="50px" bottom_margin="50px" border_size="" icon="" icon_circle="" icon_circle_color="" width="" alignment="center" /][fusion_syntax_highlighter theme="" language="md" line_numbers="" line_wrapping="" copy_to_clipboard="" copy_to_clipboard_text="Kopyala" hide_on_mobile="small-visibility,medium-visibility,large-visibility" class="" id="" font_size="" border_size="" border_color="" border_style="" background_color="" line_number_background_color=""

1 06, 2018

Kripto Borsasindan API Aracılığı ile Data Çekme

By |2019-01-25T12:42:12+00:00Haziran 1st, 2018|Categories: Genel, Örnek Raporlar, Veri Hikayeleri|Tags: , , , , , , , |Yorum yok

[fusion_builder_container hundred_percent="no" equal_height_columns="no" menu_anchor="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" class="" id="" background_color="" background_image="" background_position="center center" background_repeat="no-repeat" fade="no" background_parallax="none" parallax_speed="0.3" video_mp4="" video_webm="" video_ogv="" video_url="" video_aspect_ratio="16:9" video_loop="yes" video_mute="yes" overlay_color="" video_preview_image="" border_size="" border_color="" border_style="solid" padding_top="" padding_bottom="" padding_left="" padding_right=""][fusion_builder_row][fusion_builder_column type="1_1" layout="1_1" background_position="left top" background_color="" border_size="" border_color="" border_style="solid" border_position="all" spacing="yes" background_image="" background_repeat="no-repeat" padding_top="" padding_right="" padding_bottom="" padding_left="" margin_top="0px" margin_bottom="0px" class="" id="" animation_type="" animation_speed="0.3" animation_direction="left" hide_on_mobile="small-visibility,medium-visibility,large-visibility" center_content="no" last="no" min_height="" hover_type="none" link=""][fusion_text columns="" column_min_width="" column_spacing="" rule_style="default" rule_size="" rule_color="" class="" id=""][/fusion_text][fusion_text columns="" column_min_width="" column_spacing="" rule_style="default" rule_size="" rule_color="" class="" id=""] Web'ten direkt olarak yahut API'lari kullanarak data cekmek bir suredir paylasmak istedigim konulardan biriydi. Son donemde cok populer olan kripto para borsalarindan birinden veri cekmenin ilginizi cekebilecegini dusundum.

5 02, 2018

Kelime Saydirma Fonksiyonu

By |2019-01-25T12:42:09+00:00Şubat 5th, 2018|Categories: Genel, M - Power Query - Sorgu Dili|Tags: , , , , |Yorum yok

[fusion_builder_container hundred_percent="no" equal_height_columns="no" menu_anchor="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" class="" id="" background_color="" background_image="" background_position="center center" background_repeat="no-repeat" fade="no" background_parallax="none" parallax_speed="0.3" video_mp4="" video_webm="" video_ogv="" video_url="" video_aspect_ratio="16:9" video_loop="yes" video_mute="yes" overlay_color="" video_preview_image="" border_size="" border_color="" border_style="solid" padding_top="" padding_bottom="" padding_left="" padding_right=""][fusion_builder_row][fusion_builder_column type="1_1" layout="1_1" background_position="left top" background_color="" border_size="" border_color="" border_style="solid" border_position="all" spacing="yes" background_image="" background_repeat="no-repeat" padding_top="" padding_right="" padding_bottom="" padding_left="" margin_top="0px" margin_bottom="0px" class="" id="" animation_type="" animation_speed="0.3" animation_direction="left" hide_on_mobile="small-visibility,medium-visibility,large-visibility" center_content="no" last="no" min_height="" hover_type="none" link=""][fusion_text]List.Count(List.RemoveItems(Text.SplitAny([Metin]," #(tab)#(lf)"),{""}))[/fusion_text][/fusion_builder_column][/fusion_builder_row][/fusion_builder_container]