Forum Discussion
Hide Selection but actually use data
Hello everyone, I need help creating a visual that compares the sales of Fiscal Year (FY) and Fiscal Year-1 (FY-1). Currently, I am using a slicer, and the idea is that when I select FY23, the visua...
It does not work.
I even tried this:
Last year sales =
VAR E =EDATE(MAX('01 Date Table'[Date]),-12)
VAR S = EDATE(E,-12)
VAR ACTIVE =
FILTER(
'SALES TABLE',
'SALES TABLE'[01 PostingDate]>=S
&&'SALES TABLE'[01 PostingDate]<=E
&&'SALES TABLE'[DataSource]="ACT"
)
Var result =
CALCULATE(
SUM('SALES TABLE'[Sales RESTATE]),
ACTIVE,
ALL('01 Date Table'[Date]),
ALL('SALES TABLE'[Date])
)/'Display unit'[Display unit selection]
RETURN result
FreemanZ
Super User
Super Usercould you post some data and let us see how it shall work.