Forum Discussion
Sum with calculate
- 6 years ago
Parece que queire construir una table con un record que contiene sumas para la tabla de ejemplo.
https://radacad.com/creating-a-table-in-power-bi-using-dax-table-constructor
este articulo descirbe como hacerlo in DAX. Tienia que escribir una medida para cada columna, pero las medidas pueden hacer qualquier calculacion .
Soy un personal Power Bi Trainer aprendo cada vez que respondo a una pregunta
The Golden Rules for Power BI
- Use a Calendar table. A custom Date tables is preferable to using the automatic date/time handling capabilities of Power BI. https://www.youtube.com/watch?v=FxiAYGbCfAQ
- Build your data model as a Star Schema. Creating a star schema in Power BI is the best practice to improve performance and more importantly, to ensure accurate results! https://www.youtube.com/watch?v=1Kilya6aUQw
- Use a small set up sample data when developing. When building your measures and calculated columns always use a small amount of sample data so that it will be easier to confirm that you are getting the right numbers.
- Store all your intermediate calculations in VARs when you’re writing measures. You can return these intermediate VARs instead of your final result to check on your steps along the way.
Parece que queire construir una table con un record que contiene sumas para la tabla de ejemplo.
https://radacad.com/creating-a-table-in-power-bi-using-dax-table-constructor
este articulo descirbe como hacerlo in DAX. Tienia que escribir una medida para cada columna, pero las medidas pueden hacer qualquier calculacion .
Soy un personal Power Bi Trainer aprendo cada vez que respondo a una pregunta
The Golden Rules for Power BI
- Use a Calendar table. A custom Date tables is preferable to using the automatic date/time handling capabilities of Power BI. https://www.youtube.com/watch?v=FxiAYGbCfAQ
- Build your data model as a Star Schema. Creating a star schema in Power BI is the best practice to improve performance and more importantly, to ensure accurate results! https://www.youtube.com/watch?v=1Kilya6aUQw
- Use a small set up sample data when developing. When building your measures and calculated columns always use a small amount of sample data so that it will be easier to confirm that you are getting the right numbers.
- Store all your intermediate calculations in VARs when you’re writing measures. You can return these intermediate VARs instead of your final result to check on your steps along the way.