Filter Transactions into Max and Min

Question

Dear BI Champs,&nbsp;I need help in sorting the following Transactions into Max and Min based on Qty and Total of a particular day / week / month:&nbsp;&nbsp;Table:&nbsp;Transactions&nbsp; Item Name Qty Price Total Date1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Car&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp;10&nbsp; &nbsp; 10&nbsp; &nbsp;16 Feb 20181&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Plane&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp;20&nbsp; &nbsp; 20&nbsp; &nbsp;16&nbsp;Feb&nbsp;20182&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Bike&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp;10&nbsp; &nbsp;16&nbsp;Feb&nbsp;20183&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Car&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp;10&nbsp; &nbsp; 10&nbsp; &nbsp;16&nbsp;Feb&nbsp;20183&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Boat&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp;20&nbsp; &nbsp; 40&nbsp; &nbsp;16&nbsp;Feb&nbsp;2018&nbsp;Thanking in advance.....&nbsp;Regards,M Shakir

v-yulgu-msft · Answer

Hi&nbsp;shakirkhanani,
&nbsp;
Could you please illustrate "sorting the following Transactions into Max and Min based on Qty and Total of a particular day / week / month" with examples?
&nbsp;
Based on above sample table, what is your desired output?
&nbsp;
Below is the result I have got based on my assumption.
Create two calculated columns
Rank = RANKX(Table_1,Table_1[Total],,DESC,Dense)

Min/Max =
IF (
    Table_1[Rank] = 1,
    "Max",
    IF ( Table_1[Rank] = MAX ( Table_1[Rank] ), "Min", BLANK () )
)

&nbsp;
Regards,
Yuliana Gu

ashish_mathur · Answer

Hi,&nbsp;What result are you expecting?

Forum Discussion

Filter Transactions into Max and Min

2 Replies

Related content

Most Recent Transaction

Multiple SaveChanges without transaction

Previous transaction

Filter

DAX for transacting accounts