Forum Discussion
CALENDAR FUNCTION
hi Team, Can measures be entered a input into the Calendar Function? e.g. Calendar(<measure1>, <measure2>) Thanks
Anonymous_001 weird, it should work, end date is greater than equal to the start date? Is it date or date/time?
parry2k, the end date is greater than start date. This is the formula which returns blank values
CALENDAR([MINOR], [MAJOR])
MINOR is a calculated measure returning oldest date from data. Testing it on Card Visual returns 21/08/23. Measure has format dd/mm/yy
MAJOR is a calculated measure returning latest date from data. Testing it on Card Visual returns 22/07/24. Measure has format dd/mm/yy