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. ...
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!

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

    I use this table as the date table

     

     

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

      I do not understand..

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

        I don't have a date table in my model