Creating Measures (or DAX?) in Power Pivot

gwoolley0302

New Member
Joined
May 13, 2014
Messages
48
Hello,

I'm looking for some guidance with if and how I could use measures to help me create some enhanced pivot tables.

I have detailed a couple of specific questions in the document here (in red text in the Sheet: Pivot Test): s666-PQ-Impact system 2019.11.15a-ver4.xlsx

But to summarise I'm looking to:
1. summarise the results of 4 columns in one pivot into 2, whereby in the new table column 1 = column 1 of the of the original table, but column 2 of the new table should represent column 2,3 and 4 of the original table.
2. *apply an IF statement to selected specific rows for a summary calculation, for instance I think I might need to create a measure of some kind for the data in Sheet 6, such as: "=If(E5 + E8 + E11 + E14 > 0), "Yes", "No"). But that is one student and one parent category. I would want to repeat that calculation for every student and every parent category.

* But I think this may be easier to understand from looking at the spreadsheet.

Any help you can give would be really appreciated!

Greg
 

nikio8

Board Regular
Joined
Oct 20, 2017
Messages
128
you can write calculated columns in your data model. have you used "switch" for multiple if else ?
tricky part with measure is that you should create new measure for each column, that way you can reference them later, rather than referencing something like "sum of columnName"
 

Forum statistics

Threads
1,077,723
Messages
5,335,837
Members
399,051
Latest member
WPO

Some videos you may like

This Week's Hot Topics

Top