Cant export data from matrix to csv file

[LFM]

Hello. I have an issue. I want to export a matrix to a csv file, because I want to do a check that the data is tranformed in the right way. The export data button is greyed out. 

In the matrix I used "New calculation", which makes it not working. Its working if I insert columns or measures. The function I used is unfortunately not working for measure.
I used this function that shows how much the values have changed from the previous date:

Delta = 
var pv=NEXT([Sum of Required Margin])
return if(not ISBLANK(pv),format([Sum of Required Margin]-pv,"#"))

F.eks. like this

20,05.2024	-14020713
17.05.2024	-14223426
Change	202713

How can I solve this issue?

[Anonymous · Accepted solution]

Hi @LFM ,

You may need to create index with the help of power query and then try the following measure:

In this case, you can use the export data function normally.

Delta =
VAR index_ =
    MAX ( Your[Index] )
VAR pre_ =
    CALCULATE (
        MAX ( Your[Value] ),
        FILTER ( ALL ( Your ), Your[Index] <= index_ + 1 )
    )
RETURN
    IF ( NOT ISBLANK ( pre_ ), pre_ - MAX ( Your[Value] ) )

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.