Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Use CALCULATE() without using expression

Hello people  🙂 First of all, here's my PBI file: test2  I have a small problem in a calculated table that I created. My standard table follows this structure: COD DATE LEVEL 00 12/01/2...
Need Help
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous ,

    Try like

    filter(SUMMARIZE('table'; 'table'[COD]; 'table'[LEVEL]; 'table'[DATE],"max_dt"CALCULATE(MAX('table'[DATE]);ALLEXCEPT('table';'table'[COD])))
,[DATE]=[max_dt])
amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous ,

Try like

filter(SUMMARIZE('table'; 'table'[COD]; 'table'[LEVEL]; 'table'[DATE],"max_dt"CALCULATE(MAX('table'[DATE]);ALLEXCEPT('table';'table'[COD])))
,[DATE]=[max_dt])
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thank you so much amitchandak !!!!!
    This is exactly what I want!