Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Simple thing.
I have a KPI from charts and just want to show the total count of 'Date Created' for the last 30 days and then another the count on the previous 30 days.
I have this at the moment:
Count({<[Date Created]*={'11/02/2020'}>}[Date Created]) But this only shows for the one date.
Any direction on this gratefully accepted.
Thanks
Try this
Count({<[Date Created] *= {">=$(=Date(Today(1) - 30, 'DD/MM/YYYY'))<=$(=Date(Today(1), 'DD/MM/YYYY'))"}>} [Date Created])
I missed closing parenthesis when I posted this expression above. You can see the evaluation of your set analysis right underneath
Thats done it! - thanks very much for your help and patience.