Forum Discussion
Apply Pivot Table on selected items with addition filter of billed in current quarter only
Let assume you your Excel version/platform supports data model. Creating PivotTable you need to add data to data model:
Right click on table name In PivotTable Fields pane and Add measure
Create DAX measure in opened window
Use this measure in PivotTable for aggregation
vt_excel Not sure that a pivot table is what you need. I created something in Power Query that seems to achieve the desired output, based on the conditions you mentioned. See if you can get it to work on your real data.
- Hi Riny_van_Eekelen
How you have used power query and what filer/formula applied? I will check at my excel too.vt_excel Well, when you open the Advanced Editor in Power Query, you can see the applied steps that take you from the blue table to the green one. It's not very straight-forward if you haven't worked with PQ before. Have you?
Riny_van_Eekelen Thanks for reply.
Havent worked in PQ before.
Can you suggest some right links, i am searching online also..
