Can you please help in creating a measure using DAX to fulfil the 4 conditions below? Also the total amount should be summing up the rows after the conditions are applied.
1. If Company, Cost Center & Posting Period for Doc Type "PY" is the same as "PD", take "PD" amount
2. In the absence of "PD" for the same Company, Cost Center & Posting Period, take "PY" amount
3. In the absence of "PY" for the same Company, Cost Center & Posting Period, do not take "PD" amount
4. The rest of the Doc Type i.e. AP or JE should remained unchanged
I appreciate any help. Thanks!
@Joanne Try this, PBIX is attached below signature. You want Table28 and Page 6.
Measure 3 =
VAR __PY = MAXX(FILTER('Table28',[Doc Type]="PY"),[ Amount ])
VAR __PD = MAXX(FILTER('table28',[Doc Type]="PD"),[ Amount ])
NOT(ISBLANK(__PD)) && NOT(ISBLANK(__PY)),__PD,
NOT(ISBLANK(__PY)) && ISBLANK(__PD),__PY,
NOT(ISBLANK(__PD)) && ISBLANK(__PY),BLANK(),
MAX('Table28'[ Amount ])
Measure 3 Total =
VAR __Table = SUMMARIZE('Table28',[Company],[Cost Center],[Posting Period],[Doc Type],"__Measure",[Measure 3])
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.