Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

New Items

Hi,   I have data that has UPCs and sales data for them. My data is structured in a way that I have 4 times for data. Latest 4 weeks, latest 13 weeks, latest 26 weeks and latest 52 weeks and for ea...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous 

Due to I don’t know what do the values like UPCS,SALES, UNITS ,CUR ,YAG mean, I use your value and build the column head by myself to have a test.

Table:

And I build a measure to find the value whose Status = Sales and Time frame = CUR and Date = LATEST 04 WKS to flag as “New”.

 

New = IF( MAX('Table'[Status])="SALES"&&MAX('Table'[Time frame])="CUR"&&MAX('Table'[Date])="LATEST 04 WKS","NEW",BLANK())

 

Result：

And I build another sample for you which I hope it can help you.

If this reply still couldn’t help you to solve this problem please provide me more details about your column headers and the meaning or each values like UPCS, CUR,YAG ACVMAX ,UNITS and I think there should exist value format like yyyy/mm/tt in your table you should show them to me, or you can provide me with your pbix file from your onedrive for business.

You can download the pbix file from this link: New Items

 

Best Regards,

Rico Zhou

 

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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous 

 

Were you able to look at my last responses to your solution?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous 

    Sorry for responing late. I build a new table2, and add some values in it.

    Then I build a new measure to achieve your goal:

     

    New 2 = 
VAR _Avg =
    CALCULATE (
        AVERAGE ( Table2[Amount] ),
        FILTER (
            ALL ( Table2 ),
            Table2[UPCS] = MAX ( Table2[UPCS] )
                && 'Table2'[Status]
            = MAX ( 'Table2'[Status] )
            && Table2[Time frame] = MAX ( 'Table2'[Time frame] )
    ))
VAR _Min =
    CALCULATE (
        MIN ( Table2[Amount] ),
        FILTER (
            ALL ( Table2 ),
            Table2[UPCS] = MAX ( Table2[UPCS] )
                && 'Table2'[Status]
            = MAX ( 'Table2'[Status] )
            && Table2[Time frame] = MAX ( 'Table2'[Time frame] )
    ))
RETURN
    IF (
        _Avg = _Min
            && MAX ( 'Table2'[Status] ) = "SALES"
            && MAX ( 'Table2'[Time frame] ) = "CUR"
            && MAX ( 'Table2'[Date] ) = "LATEST 04 WKS",
        "New",
        BLANK ()
    )

    This measure will mark the one whose 04 Amount = 13/26/52 Amount, Statues = Sales and Time Frame = Cur as New.

     

    You can download the pbix file from this link: New Items

     

    Best Regards,

    Rico Zhou

     

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