topic Re: I need help please on DAX in DAX Commands and Tips

I need help please on DAX

majid_75 — Fri, 19 Jan 2024 18:53:46 GMT

I have a table that’s like this

And I want to get the max on the previous periods but that when I have a limit

Thanks!

Re: I need help please on DAX

gmsamborn — Fri, 19 Jan 2024 22:34:19 GMT

Hi majid_75

I have a few questions regarding your data and expected results.

1) Values in the 1st table seem to be 1000 times bigger than those in the 2nd table.

2) Can you explain your results in [exposition] column? (2nd table)

- How did you arrive at these numbers?

3) Do you only want result for 3M, 6M, 1Y or does that list change?
- If it changes, please explain.

4) Why do the following have 2 rows? 0D, 1D, 2D, 3D

Re: I need help please on DAX

gmsamborn — Fri, 19 Jan 2024 22:51:08 GMT

Hi majid_75

Another question...

Regarding your [Exposition] column, It appears that you want the [exposition] value for earliest date after the previous “limite” date?

That rule would work for 3M and 6M but the value for 1Y would be 23,291. Your 1Y result is from the previous row (26,456), not like the rule I outlined above. Can you explain why?

I hope this makes sense.

Re: I need help please on DAX

majid_75 — Mon, 22 Jan 2024 08:31:16 GMT

Hi,

Yes exactly, i want the [exposition] value for earliest date after the previous “limite” date.

For 1Y, my max it's 26 456 on my previous period (with a limit)

Re: I need help please on DAX

majid_75 — Mon, 22 Jan 2024 08:35:51 GMT

Hi,

1) It's just the unit, the first in € but the second is K€

2) the [exposition] value for earliest date after the previous “limite” date

3) It's a display static, i want only 3M, 6M, 1Y, 2Y and 5Y.

4) sorry it's just different category

Re: I need help please on DAX

gmsamborn — Mon, 22 Jan 2024 22:21:55 GMT

Hi majid_75

You said: "Yes exactly, i want the [exposition] value for earliest date after the previous “limite” date."

With the data supplied, shouldn't the result for 1Y be 23290? It is the earliest record after the previous "limite" record.

Your result of 26456 is the latest record after the previous "limite" record, not the earliest.

can you confirm this?

Also, can you provide data that a) doesn't have duplicate values for [Maturity] and b) covers 2Y and 5Y ?