Forum Discussion
Count columns containing date & time
Hi LeighMacKay,
Due to it is hard to reproduce your data, could you please offer some sample data to have a test and post your desired result if possible? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Regards,
Daniel He
Hi,
Apologies that I am only just getting back to you, I appreciate your response.
Commission & Event Value table names are actually as follows ...
Commission = 'tblEvents'[approxCommission]
Event Value = 'tblEvents'[approxValue]
I've got the total values in at the bottom of each column to show what I should be getting based on the filters that are being applied. Any hints or tips to make my cards work would be greatly appreciated.