Forum Discussion
Power BI Functions
I entered your sample data and got the desired outcome. If you can share your pbix via one of the file services like OneDrive, I'll take a look.
Hi and thanks for taking the time to respond.
It does work but I may not have been entirely clear with my question. It looks to the latest statement date however I did not mention that the customer ID may not appear in all months so it may not always be the latest months statement if the customer did not appear and could be May's statement date where the latest rate appears for the customer.
The measure does pick up the correct rates but only for customers who appear within the latest statement date but not all customers appear every month, so the measure would need to identify the latest statement month the cust ID appears in and then return the rate from there? Thanks
Would you be able to provide an example of this scenario and screenshots of current and expected results? In my testing, I'm not seeing the issue.
Hi please see screenshot below of sample of data and expected outcomes, thanks
I entered your sample data and got the desired outcome. If you can share your pbix via one of the file services like OneDrive, I'll take a look.
Hi I have re entered the formula and it is now working so the error was on myside, apologies for this and thanks for your help and time spent on this, it now works perfectly.