Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I need a static KPI for the last 30 days with no reference to the filters. What I'm doing wrong?
That's my function:
Sum({1< date = {"=date >= Today() - 30"} >} [sales])
This function for last month works fine, but i need last 30 days. Where is the difference?
Sum( { 1< [date.autoCalendar.MonthsAgo]={1} > } [sales] )
Thank you!
Hi @Timste
Try like below
Sum({1< date = {">= $(=Date(Today() - 30,'YourDateFormat')"} >} [sales])
Hey Mayil, thank you for the reply but this doesn't work for me. Maybe my function was a little bit confusing because of the fieldname "date". So this is my function. This works fine without using filters.
Sum({1< invoicedate = {"=invoicedate >= Today() - 30"} >} [sales])
I also tried it with the dateformat, but without success. Any idea?