Forum Discussion

Nihed's avatar
Nihed
Icon for Helper III rankHelper III
4 years ago

Dax Help

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:

 

 

 

5 Replies

  • Whitewater100's avatar
    Whitewater100
    Icon for Solution Sage rankSolution Sage
    4 years ago

    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!

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.