Forum Discussion
OAMKEM1
3 years agoRegular Visitor
Time Intellegence is not working
Hi to all, I am having an issue with time intelligence, which realy drives me crazy.. Iam not to able to have the currunt period + YTD. Please note the following: - The wanted results ...
devanshi
Helper V
3 years agoMonthytd = TOTALYTD(SUM([Sale column name]),[Date])
YTD =
VAR selected = SELECTEDVALUE(MONTH[Date])
RETURN
IF(selected , selected && Monthytd, [Sale column name] )