Dax formula for Max date and vaues

[Anonymous]

Hi,

I am looking for measure, where i can find the correct value of current and previous month.

I have my landed rate in table. its variying based on every day.

i need to calculate value of latest date with landed rate. I am attaching the screen shot.

please give possible solution.

[Anonymous]

HI @Anonymous,

It seems like you shared a snapshot with pivoted multiple table fields, they should not help us to clarify your data structure to test.

Can you please share a pbix or some dummy data that keep raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[lbendlin]

Please provide sanitized sample data that fully covers your issue. I cannot help you without usable sample data.
Please paste the data into a table in your post or use one of the file services like OneDrive or Google Drive. I cannot use screenshots of your source data.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523