top of page
![](https://static.wixstatic.com/media/533537_3d09583e9cd04d1eaa3de70ce7d05ce9~mv2.webp/v1/fill/w_250,h_250,al_c,q_30,blur_30,enc_auto/533537_3d09583e9cd04d1eaa3de70ce7d05ce9~mv2.webp)
![Advantages of using DAX Query View in Power BI | Xyclos](https://static.wixstatic.com/media/533537_3d09583e9cd04d1eaa3de70ce7d05ce9~mv2.webp/v1/fill/w_289,h_217,al_c,q_90,enc_auto/533537_3d09583e9cd04d1eaa3de70ce7d05ce9~mv2.webp)
Carlos Altamirano
Jul 12 min read
Advantages of using DAX Query View in Power BI | Xyclos
In Power BI Desktop we have a very useful tool to visualize the results of DAX instructions before using them in our Model. It is called...
100
![](https://static.wixstatic.com/media/533537_ef79d8c969cb49b8998174173f23b4a1~mv2.webp/v1/fill/w_250,h_250,al_c,q_30,blur_30,enc_auto/533537_ef79d8c969cb49b8998174173f23b4a1~mv2.webp)
![Create custom Data Model pages in Power BI Desktop | Xyclos](https://static.wixstatic.com/media/533537_ef79d8c969cb49b8998174173f23b4a1~mv2.webp/v1/fill/w_289,h_217,al_c,q_90,enc_auto/533537_ef79d8c969cb49b8998174173f23b4a1~mv2.webp)
Carlos Altamirano
Jun 273 min read
Create custom Data Model pages in Power BI Desktop | Xyclos
Introduction In the world of data analysis, a well-structured Data Model is the backbone of any Business Intelligence project. In Power...
220
![](https://static.wixstatic.com/media/533537_cd46227818584ac3910ac775d762466d~mv2.webp/v1/fill/w_250,h_250,al_c,q_30,blur_30,enc_auto/533537_cd46227818584ac3910ac775d762466d~mv2.webp)
![Learn the processes and components of Power BI Desktop | Xyclos](https://static.wixstatic.com/media/533537_cd46227818584ac3910ac775d762466d~mv2.webp/v1/fill/w_289,h_217,al_c,q_90,enc_auto/533537_cd46227818584ac3910ac775d762466d~mv2.webp)
Carlos Altamirano
Jun 202 min read
Learn the processes and components of Power BI Desktop | Xyclos
This is an introduction to the process and components we have in the Power BI Desktop application, for Windows. Power Query It is the...
90
![](https://static.wixstatic.com/media/533537_54cc6cab4c1e46209092b5db62be80e5~mv2.webp/v1/fill/w_250,h_250,al_c,q_30,blur_30,enc_auto/533537_54cc6cab4c1e46209092b5db62be80e5~mv2.webp)
![Are you looking for the best Basic Intermediate Business Excel course? | Xyclos](https://static.wixstatic.com/media/533537_54cc6cab4c1e46209092b5db62be80e5~mv2.webp/v1/fill/w_289,h_217,al_c,q_90,enc_auto/533537_54cc6cab4c1e46209092b5db62be80e5~mv2.webp)
Carlos Altamirano
Jun 132 min read
Are you looking for the best Basic Intermediate Business Excel course? | Xyclos
In April of this year 2024, I trained several people from a company in the Basic Intermediate Business Excel course. I evaluated their...
30
![](https://static.wixstatic.com/media/533537_c5b79f03382348ec8aa9bc3fff3adcee~mv2.webp/v1/fill/w_250,h_250,al_c,q_30,blur_30,enc_auto/533537_c5b79f03382348ec8aa9bc3fff3adcee~mv2.webp)
![Create button to clear all applied slicers in Power BI | Xyclos](https://static.wixstatic.com/media/533537_c5b79f03382348ec8aa9bc3fff3adcee~mv2.webp/v1/fill/w_289,h_217,al_c,q_90,enc_auto/533537_c5b79f03382348ec8aa9bc3fff3adcee~mv2.webp)
Carlos Altamirano
Jun 62 min read
Create button to clear all applied slicers in Power BI | Xyclos
Have you ever found yourself browsing a Power BI report with multiple slicers applied and wishing you could delete them all with a single...
110
![Advanced methods to concatenate cells | Microsoft Excel | Xyclos](https://static.wixstatic.com/media/533537_8b6b45258de34c25be2ecfd55abd8af0~mv2.png/v1/fill/w_289,h_217,fp_0.50_0.50,q_95,enc_auto/533537_8b6b45258de34c25be2ecfd55abd8af0~mv2.webp)
Carlos Altamirano
May 222 min read
Advanced methods to concatenate cells | Microsoft Excel | Xyclos
When we need to concatenate or join cells, we have several functions that can help us with this: Concatenate Concat Textjoin Suppose we...
270
![](https://static.wixstatic.com/media/533537_94e1d9861d29405b9efa6efd66ea8911~mv2.webp/v1/fill/w_250,h_250,al_c,q_30,blur_30,enc_auto/533537_94e1d9861d29405b9efa6efd66ea8911~mv2.webp)
![With Power Query everything is easier | Xyclos](https://static.wixstatic.com/media/533537_94e1d9861d29405b9efa6efd66ea8911~mv2.webp/v1/fill/w_289,h_217,al_c,q_90,enc_auto/533537_94e1d9861d29405b9efa6efd66ea8911~mv2.webp)
Carlos Altamirano
Apr 194 min read
With Power Query everything is easier | Xyclos
Case to solve The other day a client called me who had the following problem. On the one hand, it has a book currently made up of 3 tabs...
30
![](https://static.wixstatic.com/media/533537_a7da21613a4a4b2cbb82a91b5af8300b~mv2.jpg/v1/fill/w_250,h_250,fp_0.50_0.50,q_30,blur_30,enc_auto/533537_a7da21613a4a4b2cbb82a91b5af8300b~mv2.webp)
![Concept: Granularity in Power BI and Microsoft Excel | Xyclos](https://static.wixstatic.com/media/533537_a7da21613a4a4b2cbb82a91b5af8300b~mv2.jpg/v1/fill/w_289,h_217,fp_0.50_0.50,q_90,enc_auto/533537_a7da21613a4a4b2cbb82a91b5af8300b~mv2.webp)
Carlos Altamirano
Apr 131 min read
Concept: Granularity in Power BI and Microsoft Excel | Xyclos
What is granularity or granularity applied to a Data Model? Granularity is the level of detail that a table contains. In principle it can...
110
![](https://static.wixstatic.com/media/533537_42c2293ed5ff49e3ba85b759b20661dc~mv2.jpg/v1/fill/w_250,h_250,fp_0.50_0.50,q_30,blur_30,enc_auto/533537_42c2293ed5ff49e3ba85b759b20661dc~mv2.webp)
![Convert a date to month as text | Microsoft Excel | Xyclos](https://static.wixstatic.com/media/533537_42c2293ed5ff49e3ba85b759b20661dc~mv2.jpg/v1/fill/w_289,h_217,fp_0.50_0.50,q_90,enc_auto/533537_42c2293ed5ff49e3ba85b759b20661dc~mv2.webp)
Carlos Altamirano
Apr 43 min read
Convert a date to month as text | Microsoft Excel | Xyclos
We are going to learn how to display and how to extract the month from a date, along with other examples that include the day and year....
2720
![](https://static.wixstatic.com/media/533537_3b6f98aa0d9646479fa2e3a54d749460~mv2.webp/v1/fill/w_250,h_250,al_c,q_30,blur_30,enc_auto/533537_3b6f98aa0d9646479fa2e3a54d749460~mv2.webp)
![The secret to professional success: UP-Skills, RE-Skills | Xyclos](https://static.wixstatic.com/media/533537_3b6f98aa0d9646479fa2e3a54d749460~mv2.webp/v1/fill/w_289,h_217,al_c,q_90,enc_auto/533537_3b6f98aa0d9646479fa2e3a54d749460~mv2.webp)
Carlos Altamirano
Apr 33 min read
The secret to professional success: UP-Skills, RE-Skills | Xyclos
Skills We all have one or more abilities or skills that we have acquired over time by performing certain tasks with safety and...
160
bottom of page