Two lines at the same line

[JMAROUF]

Hi,

i have an issue to show two transactions at the same line, i want to show the first and the second transactions of the max dates  at the same line, it's possible? here's the model and the result desired:

The output desired:

the invested_position of the max date and position investor of the max date, can any one help please?

[JMAROUF · Accepted solution]

I have solved the problem by duplicating the fact and linked it to investors as invested and adding a flag to the transaction fact (max_date by invested_investor) and adding the two formulas in dimension and expression with excluding null values:

=IF(max_date=date and PFGI=1 AND PFPP=1,ID_INVESTED)

=max(IF(max_date=date and PFGI=1 AND PFPP=1,POSITION))