Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Dax formula for Max date and vaues

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.

 

Need Help

2 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    4 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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