Dax Help

[Nihed]

Hello,

Can someone give me an idea about this problem please,

These rates may change on a monthly basis. In the table above, the most recent rate in the period should be displayed.

Example: if 2022 Q2 is selected in the filter, the rate of June 2022 must be displayed (Last month of the quarter)

my Data:

[Anonymous]

Hi @Nihed ,

I suggest you to create a continuous date table by calendar/calendarauto function. I can see last day of quarter which is in date format in second screenshot date table. However I couldn't see date in your first data screenshot. Did you created a relationship between your date table and your data table? If there is an active relationship by [Quarter/Year] columns, I think your visual will show all values in 2022 Q2 when you select it in slicer. I am still confused about what kind of result you want. Could you share a sample file with me and show me a screenshot with the result you want? This will make me easier to find the solution.

Best Regards,
Rico Zhou

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

[Whitewater100]

I can't see your data model and if you have a date table.

Normally you can do Closing Qtr Rate = CLOSINGBALANCEQUARTE( [Measure for your rate], Dates[Date])

If you have sample data model I can take another look.

If you have a date table named Dates and have marked it as so.

Hope this helps!

[Nihed]

I use this table as the date table

[Whitewater100]

I do not understand..

[Nihed]

I don't have a date table in my model