Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello dear community,
Can someone help me to create a condition about the date where date = Today -29days
Where should this condition be applied?
- In an expression for a measure?
- For filtering out dates in a date dimension+
- Will it be used in the load script?
- Will it be used in your visualization?
You con write:
=date(today()-29,'DD/MM/YYYY')
It will be used in the load script
Thank you for your answer but I have this error above in the pictures
In the script ...
where Date > date(Today() - 29)
you can check with your Date field format, your Date Field should be same as your condition date format.
or else you can upload the sample app.
Try
define a variable in script
Let vFilterDate=Date(today()-29,'DD/MM/YYYY');
in the where condition, use as below
Date>'$(vFilterDate)'