Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Report filter automatic result

Hello experts!   I need to filter the report to recognize the most recent date, then filter to only show results for the group of that date. For example...   The most recent event date on the dat...
v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
10 years ago

Hi Pchapple,

 

Yes, create calculated column in the original table. Please share us the error message, so that we can make further analysis.

 

Regards,

Charlie Liao

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hi v-caliao-msft

Have created the column as suggested however the process for creating a table seems unclear.  Maybe Im not creating the table rtight, but it does not seem that the formulae works when I use ENTER DATA to create a new table.

 

You say "Then create a new table
LatestEvent = SUMMARIZE(Latest,Latest[Event#])" however this does not seem to return any results when pasted into the 1st cell

 

Thanks

  • v-caliao-msft's avatar
    v-caliao-msft
    Microsoft Employee
    10 years ago

    Hi Pchapple,

     

    I have create a table by using Enter Data, everything works fine. Here are the steps for you reference.

    1. Create a table using Enter Data (change the table name to Latest) and then click Loda button.
    2. Click Data on the left pane, and click Modeling the click New Column. Type the DAX below.
      LatestDate = CALCULATE(MAX(Latest[DATE]),ALLEXCEPT(Latest,Latest[Event#]))
    3. Click New Table and type the DAX below.
      LatestEvent = SUMMARIZE(Latest,Latest[Event#])
    4. Add those columns to the new created table.
      LatestDate = LOOKUPVALUE(Latest[LatestDate],Latest[Event#],LatestEvent[Event#])
      RevCat1 = LOOKUPVALUE(Latest[RevCat1],Latest[DATE],LatestEvent[LatestDate],Latest[Event#],LatestEvent[Event#])
      RevCat2 = LOOKUPVALUE(Latest[RevCat2],Latest[DATE],LatestEvent[LatestDate],Latest[Event#],LatestEvent[Event#])
      RevCat3 = LOOKUPVALUE(Latest[RevCat3],Latest[DATE],LatestEvent[LatestDate],Latest[Event#],LatestEvent[Event#])
      RevCat4 = LOOKUPVALUE(Latest[RevCat4],Latest[DATE],LatestEvent[LatestDate],Latest[Event#],LatestEvent[Event#])
      RevCat5 = LOOKUPVALUE(Latest[RevCat5],Latest[DATE],LatestEvent[LatestDate],Latest[Event#],LatestEvent[Event#])

     

    Regards,

    Charlie Liao