Forum Discussion
Calculation Fixed:MAX
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
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.
3 Replies
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]) )
looks like I'm not getting it
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.
