Forum Discussion

Titus_D's avatar
Titus_D
Helper I
5 years ago
Solved

Latest date

Hi Experts,   I am new to Power BI and have a question, i know how to get this in a pivot in excel but trying hard to convert the same idea in Power BI. I have data as below.   Type(From table...
Need Help
  • FrankAT's avatar
    FrankAT
    5 years ago

    Hi Titus_D 

    you can create this formula like this:

    1. Right click table name in field list, choose New Measure.
    2. Copy and paste the formula from my previous post or write it manuelly into the formulabar.
    3. Press Enter.

    With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
    FrankAT (Proud to be a Datanaut)

     

FrankAT's avatar
FrankAT
Community Champion
5 years ago

Hi Titus_D 

what about the following solution:

 

Max Date = CALCULATE(MAX('Table'[Created on]),ALLEXCEPT('Table','Table'[Type]))

 

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

Titus_D's avatar
Titus_D
Helper I
5 years ago

FrankAT  thanks for your response.

 

I am completely new to Power BI so excuse me for some basic questions. Where is the place where i put that formula? Should i click on the column in the visualisation pane and then right click and select quick measure and put the formula there?

  • FrankAT's avatar
    FrankAT
    Community Champion
    5 years ago

    Hi Titus_D 

    you can create this formula like this:

    1. Right click table name in field list, choose New Measure.
    2. Copy and paste the formula from my previous post or write it manuelly into the formulabar.
    3. Press Enter.

    With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
    FrankAT (Proud to be a Datanaut)