Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi, i want to show a filed with string value, but with a condition. which function i can use?
can you elaborate little more about your requirements?
this is my expression:
({<[d Gregorian Full Date]={"$(=Date((today()-2),'YYYY-MM-DD'))"}>}
i want to show value of X field when the condition is true
Only({<[d Gregorian Full Date]={"$(=Date((today()-2),'YYYY-MM-DD'))"}>}
but it shows nothing
Maxstring({<[d Gregorian Full Date]={"$(=Date((today()-2),'YYYY-MM-DD'))"}>}
it shows nothing
it shows nothing , maybe because i have no data related to this value (i had no X for [d Gregorian Full Date]={"$(=Date((today()-2),'YYYY-MM-DD'))"}). so it is showing nothing. how is it possible to show the X values which exist in Dimension table but i have no related data in my Fact tables?