Create a table with calculated column

[bapt69]

Hi everyone,

First of all, here is the dataset (in red, tables I will talk about in this topic) :

And I would like this :

Here my problem :

The status is a status_type (VIP, CLUB, CLUB sans CIT, Anonyme) related to the differents status the customer had in a period. All is ok when the period is fixed (no filter => each customer has one and only one status_type anyway).

The best would be the status_type change when I change the period (fe : fiscal year). This status_type is calculated with a level status (le level status in a period is in d_client_histo)

In this related topic : https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dynamic-column-with-period/m-p/3109571#M10976... => the measure give me the good status_type when I change the period. But I can put this measure on rows.

In the visual, I got several measures (simple measures like that : calculate(sum(blabla),blabla)) that reach the datas from tables f_entree and f_session_mas.

I'm not sure that I'm really clear. Ask me more information if you need something.

[bapt69]

the columns "Nb", "Statut_type", "Visites" and "Coin_in" are measures.

And I would like aggregate "Visites", "Coin_in" and "Nb" by "Status_Type"