Can I replicate Excel pivot table functionality in Power BI? Can I cross-filter data in a pivot table with other visuals? Can I export a Power BI pivot table to Excel while preserving its structure? Can I use bookmarks to save different views of a pivot table in Power BI? Author Joleen...
Solved: I need to create a new table combining six columns into two columns and keep the identifiers. The exisiting table is: question_id
Comments posted to this topic are about the item Creating Tables in Power BI Sean McLarty Valued Member Points: 57 More actions May 2, 2022 at 6:02 am #4025305 One more DAX expression to try. Note that DATATABLE() has some limitations, e.g. TODAY() & NOW() can't be used as...
Power BI analyzes the selected data and creates a column chart visualization. Note If you select the Date item before you select the Profit item, Power BI creates a table rather than a column chart. If you selected the data items in this order, it's not a problem. We're going to chan...
If you select the Date item before you select the Gross Sales item, Power BI creates a table rather than a column chart. If you selected the data items in this order, it's not a problem. We're going to change the visualization of the data in the next step. Let's try a different...
Solved: I have a data table and would like to create a new table based on multiple criteria (if it's possible to do this by grouping or modifying the
In the dataflow authoring tool in the Power BI service, select Edit tables, then right-click on the table you want to use as the basis for your computed table and on which you want to perform calculations. In the context menu, choose Reference. For the table to be eligible as a ...
1.) find previous years sheets that have data i need in my new workbook -create a sheet for each year of data and then in each worksheet create a table with the historical data from that year -then create a separate worksheet that will become my master copy that will combine all ...
4) How can you limit the rows of the calculated table based and what else may be filtered on the page. I assume crossfilter? 0 thurston howell 7 months ago Reply to thurston howell I got the % of Grand Total to work adding an explicit measure. But I would like to show at the...
i need this data in a new sheet or table form that i can then sort it by location, #s, etc or a way to keep this info from previous years and then add to it this current year so it can easily be viewed what was done on the previous year etc and see everything ...