Calculation Fixed:MAX

[tbezui3]

Good day 

What can we use in powerbi to get the same result as In tableau when we use the below? 
I added a before and after I run the calculation in tableau. I also added a screen shot of the background data 
There is no need to split the date like in tableau, the date can be in one column with time in powerbi

Tableau calculation

[Calldate]={ FIXED [uniqueidentifier]:MAX([Calldate])}

This is the background data

Before 

After calculation 

note the last date entry

[v-yalanwu-msft · Accepted solution]

Hi, @tbezui3 ;

As before:

we could add matrix visual. then create a hour column.

hour = HOUR([F2])

As after:

We could create a measure to calculate the count.

Count = CALCULATE(COUNT('Table'[F2]),FILTER('Table',HOUR([F2])=HOUR(MAX([F2]))))

Then add a table visual.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[tbezui3]

looks like I'm not getting it

[amitchandak]

@tbezui3 ,

calculate(MAX([Calldate]), allexcept(Table, table[uniqueidentifier]) )

If uniqueidentifier is from a dimension then also use the table or fact

calculate(MAX(fact[Calldate]), allexcept(fact, Dim[uniqueidentifier]) )