Forum Discussion

khush19's avatar
khush19
Resolver I
5 years ago

Filter on datetime column sometime work ,sometime not

I am working on report ,where i need to take the amount based on latest datetime. For this i created a measure Total Calculated Amount = CALCULATE(sum(ParkingSessionSA[TotalAmount]),FILTER(Parking...
Need Help
khush19's avatar
khush19
Resolver I
5 years ago

Hi Greg,

 

I am using Card,to investigate the issue i created table.

and seems like for some rows even i compare int column in max ,then also it doesnt return desired result

v-diye-msft's avatar
v-diye-msft
Community Support
5 years ago

Hi khush19 

 

You might consider providing your dummy pbix that would be helpful for us to investigate it further. 

You can upload it to the onedrive for business and share the link here. please don't forget to disclose the expected results and remove the confidential info.