Forum Discussion
Comparing FY's In A Matrix From A Single Date Column Within Data Ideally Using SAMEPERIODLASTYEAR
I've searched the forums for hours now, but can't seem to find a solution that will work for me. I'm using a matrix that almost works, but not the way I want. In the matrix below, FY19 is compar...
Hi,
Try these measures:
Total Sales This FYTD = CALCULATE([Total Sales],DATESYTD('FY Date'[Date],"30/9")
Total Sales LFYTD = CALCULATE(Total Sales This FYTD,SAMEPERIODLASTYEAR('FY Date'[Date]))
Do these measures work?
Ashish_Mathur
Your 2nd measure displays (Blank) on a card.
As I said in my original message, I already have 2 measures that work correctly when displayed on separate cards. However, I need to combine the 2 measures into a single measure. When I add this new single measure into the Values field of the matrix visualization the matrix will handle the rest.
Hi,
I think there will have to be 2 measures.