Forum Discussion
Can't get the KPI visual to work correctly
Hi all, Over the past 2 days I've been eagerly trying to get the KPI visual to work the way I want to. I have a table with Sales figures from our database and used PQ to split the revenue val...
Hi Anonymous ,
Please have a try.
RevenuePY = CALCULATE(SUM(SALES[Revebue]),EDATE(MAX('Calender'[Year]),-12)).
If it does not help, please provide some data and expected output.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
It's giving me an error (I'm translating from Dutch): In the True/False expression is no column present. Each True/False expression which is being used as table filter expression, should refer to exactly one column.