Deprecated: Creation of dynamic property ACF::$fields is deprecated in D:\inetpub\wwwroot\blog.skoleni-ict.cz\wp-content\plugins\advanced-custom-fields\includes\fields.php on line 136

Deprecated: Creation of dynamic property acf_loop::$loops is deprecated in D:\inetpub\wwwroot\blog.skoleni-ict.cz\wp-content\plugins\advanced-custom-fields\includes\loop.php on line 26

Deprecated: Creation of dynamic property ACF::$loop is deprecated in D:\inetpub\wwwroot\blog.skoleni-ict.cz\wp-content\plugins\advanced-custom-fields\includes\loop.php on line 270

Deprecated: Creation of dynamic property ACF::$revisions is deprecated in D:\inetpub\wwwroot\blog.skoleni-ict.cz\wp-content\plugins\advanced-custom-fields\includes\revisions.php on line 413

Deprecated: Creation of dynamic property acf_validation::$errors is deprecated in D:\inetpub\wwwroot\blog.skoleni-ict.cz\wp-content\plugins\advanced-custom-fields\includes\validation.php on line 26

Deprecated: Creation of dynamic property ACF::$validation is deprecated in D:\inetpub\wwwroot\blog.skoleni-ict.cz\wp-content\plugins\advanced-custom-fields\includes\validation.php on line 212

Deprecated: Creation of dynamic property acf_form_customizer::$preview_values is deprecated in D:\inetpub\wwwroot\blog.skoleni-ict.cz\wp-content\plugins\advanced-custom-fields\includes\forms\form-customizer.php on line 26

Deprecated: Creation of dynamic property acf_form_customizer::$preview_fields is deprecated in D:\inetpub\wwwroot\blog.skoleni-ict.cz\wp-content\plugins\advanced-custom-fields\includes\forms\form-customizer.php on line 27

Deprecated: Creation of dynamic property acf_form_customizer::$preview_errors is deprecated in D:\inetpub\wwwroot\blog.skoleni-ict.cz\wp-content\plugins\advanced-custom-fields\includes\forms\form-customizer.php on line 28

Deprecated: Creation of dynamic property ACF::$form_front is deprecated in D:\inetpub\wwwroot\blog.skoleni-ict.cz\wp-content\plugins\advanced-custom-fields\includes\forms\form-front.php on line 603

Deprecated: Creation of dynamic property acf_form_widget::$preview_values is deprecated in D:\inetpub\wwwroot\blog.skoleni-ict.cz\wp-content\plugins\advanced-custom-fields\includes\forms\form-widget.php on line 34

Deprecated: Creation of dynamic property acf_form_widget::$preview_reference is deprecated in D:\inetpub\wwwroot\blog.skoleni-ict.cz\wp-content\plugins\advanced-custom-fields\includes\forms\form-widget.php on line 35

Deprecated: Creation of dynamic property acf_form_widget::$preview_errors is deprecated in D:\inetpub\wwwroot\blog.skoleni-ict.cz\wp-content\plugins\advanced-custom-fields\includes\forms\form-widget.php on line 36

Deprecated: Return type of mtekk\adminKit\setting\setting_base::jsonSerialize() should either be compatible with JsonSerializable::jsonSerialize(): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in D:\inetpub\wwwroot\blog.skoleni-ict.cz\wp-content\plugins\breadcrumb-navxt\includes\adminKit\setting\class-mtekk_adminkit_setting_base.php on line 66

Deprecated: Creation of dynamic property acf_field_oembed::$width is deprecated in D:\inetpub\wwwroot\blog.skoleni-ict.cz\wp-content\plugins\advanced-custom-fields\includes\fields\class-acf-field-oembed.php on line 31

Deprecated: Creation of dynamic property acf_field_oembed::$height is deprecated in D:\inetpub\wwwroot\blog.skoleni-ict.cz\wp-content\plugins\advanced-custom-fields\includes\fields\class-acf-field-oembed.php on line 32

Deprecated: Creation of dynamic property acf_field_google_map::$default_values is deprecated in D:\inetpub\wwwroot\blog.skoleni-ict.cz\wp-content\plugins\advanced-custom-fields\includes\fields\class-acf-field-google-map.php on line 33

Deprecated: Creation of dynamic property acf_field__group::$have_rows is deprecated in D:\inetpub\wwwroot\blog.skoleni-ict.cz\wp-content\plugins\advanced-custom-fields\includes\fields\class-acf-field-group.php on line 31

Deprecated: Creation of dynamic property YARPP::$is_custom_template is deprecated in D:\inetpub\wwwroot\blog.skoleni-ict.cz\wp-content\plugins\yet-another-related-posts-plugin\classes\YARPP_Core.php on line 56

Deprecated: Creation of dynamic property YARPP::$db_options is deprecated in D:\inetpub\wwwroot\blog.skoleni-ict.cz\wp-content\plugins\yet-another-related-posts-plugin\classes\YARPP_Core.php on line 69

Deprecated: Calling get_class() without arguments is deprecated in D:\inetpub\wwwroot\blog.skoleni-ict.cz\wp-includes\class-wp-http.php on line 329

Deprecated: Return type of Requests_Cookie_Jar::offsetExists($key) should either be compatible with ArrayAccess::offsetExists(mixed $offset): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in D:\inetpub\wwwroot\blog.skoleni-ict.cz\wp-includes\Requests\Cookie\Jar.php on line 63

Deprecated: Return type of Requests_Cookie_Jar::offsetGet($key) should either be compatible with ArrayAccess::offsetGet(mixed $offset): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in D:\inetpub\wwwroot\blog.skoleni-ict.cz\wp-includes\Requests\Cookie\Jar.php on line 73

Deprecated: Return type of Requests_Cookie_Jar::offsetSet($key, $value) should either be compatible with ArrayAccess::offsetSet(mixed $offset, mixed $value): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in D:\inetpub\wwwroot\blog.skoleni-ict.cz\wp-includes\Requests\Cookie\Jar.php on line 89

Deprecated: Return type of Requests_Cookie_Jar::offsetUnset($key) should either be compatible with ArrayAccess::offsetUnset(mixed $offset): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in D:\inetpub\wwwroot\blog.skoleni-ict.cz\wp-includes\Requests\Cookie\Jar.php on line 102

Deprecated: Return type of Requests_Cookie_Jar::getIterator() should either be compatible with IteratorAggregate::getIterator(): Traversable, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in D:\inetpub\wwwroot\blog.skoleni-ict.cz\wp-includes\Requests\Cookie\Jar.php on line 111

Deprecated: Return type of Requests_Utility_CaseInsensitiveDictionary::offsetExists($key) should either be compatible with ArrayAccess::offsetExists(mixed $offset): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in D:\inetpub\wwwroot\blog.skoleni-ict.cz\wp-includes\Requests\Utility\CaseInsensitiveDictionary.php on line 40

Deprecated: Return type of Requests_Utility_CaseInsensitiveDictionary::offsetGet($key) should either be compatible with ArrayAccess::offsetGet(mixed $offset): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in D:\inetpub\wwwroot\blog.skoleni-ict.cz\wp-includes\Requests\Utility\CaseInsensitiveDictionary.php on line 51

Deprecated: Return type of Requests_Utility_CaseInsensitiveDictionary::offsetSet($key, $value) should either be compatible with ArrayAccess::offsetSet(mixed $offset, mixed $value): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in D:\inetpub\wwwroot\blog.skoleni-ict.cz\wp-includes\Requests\Utility\CaseInsensitiveDictionary.php on line 68

Deprecated: Return type of Requests_Utility_CaseInsensitiveDictionary::offsetUnset($key) should either be compatible with ArrayAccess::offsetUnset(mixed $offset): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in D:\inetpub\wwwroot\blog.skoleni-ict.cz\wp-includes\Requests\Utility\CaseInsensitiveDictionary.php on line 82

Deprecated: Return type of Requests_Utility_CaseInsensitiveDictionary::getIterator() should either be compatible with IteratorAggregate::getIterator(): Traversable, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in D:\inetpub\wwwroot\blog.skoleni-ict.cz\wp-includes\Requests\Utility\CaseInsensitiveDictionary.php on line 91
ICT Pro » Mám se co naučit na školení Power BI pro pokročilé?

Síla myšlenky je neviditelná jako semeno, ze kterého vyroste obrovský strom. Je však příčinou viditelných změn v životě člověka. (L.N.Tolstoj)

Mám se co naučit na školení Power BI pro pokročilé?

Zveřejněno: 21. 02. 2023
Kategorie: ICT Pro

Ptáte se, jestli je ještě možné se posunout v analýze dat za pomoci jazyka DAX? Právě pro Vás jsme připravili ukázku ze zadání cvičení, které zpracovávají účastníci školení Power BI – Pokročilá analýza dat za pomoci jazyk DAX.

Data pro zpracování zadání najdete zde (pro stažení klikněte na tlačítko Download)

  1. Do tabulky nahrané z Excel si dopočítejte sloupce:
    1. rok
    1. mesíc
  2. Vytvořte si číselný parametr (tabulku pojmenujte pocet_nejdestivejsich_mesicu), vizuál parametru přidejte na stránku
  3. Na stránku přidejte filtr (průřez) nad sloupcem data [lokalita]
  4. Na stránku přijdete vizuál typu kontingenční tabulka
    1. řádky: data[mesic]sloupce: data[rok]
    1. hodnoty: data[srazky] s agregační funkcí suma
  5. Kontingenční tabulce nastavte podmíněné formátování, přičemž modře budou odlišeny hodnoty (měsíce v roce), které spadají do TOP N vybraných hodnot z parametru.

Tj. Pokud si uživatel vybere v parametru hodnotu 3, zobrazujeme 3 nejdeštivější měsíce v roce (3 měsíce s nevyšší sumou srážek v daném roce)

Ukázka vypracovaného zadání

Related posts:

  1. Nejen levou hemisférou živ jest programátor
  2. COVID19 – Informace pro účastníky kurzů realizovaných v našich učebnách
  3. Svět se vrací do normálu aneb Vítejte opět u nás na školení
  4. Webináře zdarma – spojování tabulek v Excelu, novinky v Power BI a další