Forum Discussion

alisag09's avatar
alisag09
Regular Visitor
3 years ago
Solved

First Record based on the Date

Hello All, I have to Tables, Products and PurchaseLines and relation is between these 2 is ItemID. To print the earliest Receipt Possible Date for a ItemID, i can use Earliest but how can i get the ...
General Comment
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi alisag09 ,

    Please refer to my pbix file.

    Create measures.

    date_ = CALCULATE(MIN(purchase[DeliveryDate]),FILTER(ALL(purchase),purchase[ItemId]=SELECTEDVALUE(products[ItemNumber])))
    Description = "Description of -" &"  "&MAX(products[ItemNumber])
    Earliest PurchdID = CALCULATE(MAX(purchase[PurchID]),FILTER(ALL(purchase),purchase[ItemId]=SELECTEDVALUE(products[ItemNumber])))

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

     

    Best Regards
    Community Support Team _ Polly

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

alisag09's avatar
alisag09
Regular Visitor
3 years ago

Hello,

Thanks Polly, but May i kNow which Table is what? Can you please rewrite the Query Using Table Names as

ItemTable & PurchTable at least for Column Query?

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi alisag09 ,

It seems you have 2 tables. Could you please provide a screenshot with your desired output? 

You can provide some data like you have provided.

And the desired output like the following, let me know  you want.

 

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.