- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Agrupacion de datos power query
Hola a todos , quisiera su ayuda para resolver el siguiente problema.
Necesito transformar esta tabla en power query
a esto
Desde ya muchas gracias a todos por su ayuda!!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @fav_ccc2021 ,
You can try the following operations:
1. In Power Query -- Select [Actividad] -- Pivot Column
2. Select all columns of the entire table -- Replace Values
3. Result:
Best regards,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @fav_ccc2021 ,
You can try the following operations:
Create a calculated column:
total no null =
var _a=IF([A]=BLANK(),1,0)
var _b=IF([B]=BLANK(),1,0)
var _c=IF([C]=BLANK(),1,0)
var _d=IF([D]=BLANK(),1,0)
RETURN
_a + _b + _c + _d
Result:
Best regards,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
esta perfecto!! solo lo ultimo, si quiero agregar una columna contando las filas no null ejemplo
gracias por la ayuda!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @fav_ccc2021 ,
You can try the following operations:
Create a calculated column:
total no null =
var _a=IF([A]=BLANK(),1,0)
var _b=IF([B]=BLANK(),1,0)
var _c=IF([C]=BLANK(),1,0)
var _d=IF([D]=BLANK(),1,0)
RETURN
_a + _b + _c + _d
Result:
Best regards,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @fav_ccc2021 ,
You can try the following operations:
1. In Power Query -- Select [Actividad] -- Pivot Column
2. Select all columns of the entire table -- Replace Values
3. Result:
Best regards,

Helpful resources
Power BI Monthly Update - July 2025
Check out the July 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
04-24-2025 09:08 AM | |||
03-27-2025 05:03 AM | |||
04-18-2025 06:18 AM | |||
03-27-2025 02:20 AM | |||
05-01-2025 10:36 PM |
User | Count |
---|---|
24 | |
9 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
11 | |
11 | |
10 | |
6 |