cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper III

## Get Sum for Current Financial Year

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.

1 ACCEPTED SOLUTION
Super User

@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.

2 REPLIES 2
Super User

@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.

Helper III

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.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors