display date when TOTAL value becomes negative

[mauroanelli]

HI ALL,

i have a matrix with a running total and i want to add a card that my report that  shows the name of the first month when the running total becomes negative

regards

[v-danhe-msft]

Hi @mauroanelli ,

Could you please post some sample data to have a test if possible?

Regards,

Daniel He

[mauroanelli · Accepted solution]

und the solution using this formula

Data fine C.I. = MINx(FILTER('Calendar';[Parziale C.I.]<0);'Calendar'[Data].[Date])

[Johanno]

Hi, you could get the first negative month by using:

FirstMonth = CALCULATE(MIN(Table1[Month]);Table2[Value]<0)

However you would get the month by the first letter in the alphabet. Do you also have the specific dates or a date table? Could you share the data?

/Johan