PowerBI : Create a new table resulting from the analysis of another table

[alexisakka]

Dear Community,

I'm trying to move my excel skills into PowerBI for profesionnal reasons.

Here is my case :
I have a table of Non Conformity (NC) with creation and closure date columns. My goal is to know the quantity of opened Non Conformity at a given time. Exemple : "On the 1st february, we had 20 non conformity, but on the 5st, we had 75 opened -> What happened?'.
The final goal is to draw the curve with time on X axis and quantity of Non conformity opened in Y axis.

I guess I need to create a new table that should look like this :

DATE	NC_ID	STATUS
01/01/2020	4848	OPENED
01/01/2020	4896	OPENED
02/01/2020	4848	CLOSED
02/01/2020	4896	OPENED

In this example, NC_ID = 4848 has been closed on the 02/01/2020.

Why I am struggling :
I perfectly know how to do that in VBA using loops, but I can't figure out how M language work for this kind of situation, despite all the artcles I read on the subject so far…
I've to admit that I'm still using the basic button to transform my data in PowerBI instead of dealing with the M language directly, and this must changes

Thanks for you help!
Alexis