Get Sum for Current Financial Year

[sarjensystems1]

Hello All,

I am looking for a dax, where I want to calculate Sales Amount for Current Financial Year Only. And while I am selecting Previous Financial Year using slicer , it won't affect Values which i am displaying for current financial year.

Thanks in advance.

[amitchandak · Accepted solution]

@sarjensystems1 , Assume you have a date table with FY

Meausre =

var _FY = maxx(filter(Date, Date[Date] =Today() ), [FY] )

return

calculate(Sum(Table[Value]), filter(all(Date), Date[FY] = _FY))

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

[sarjensystems1]

Hi @amitchandak 

I am already using another measure in which i am multiplying Sales Amount With Currency Rates.

Actual Amount for YTD = CALCULATE(SWITCH(TRUE(),

HASONEVALUE('TO CURRENCY'[ToCurrencyCode]),

Sumx( Sales, (Sales[Amount])*[TrnExchangeRate]),

SUM(Sales[Amount])))

Is there any possibilities to get Data for Current Financial Year with This.