Compare Current and Previous Financial

DonRSA — Fri, 05 May 2023 11:53:49 GMT

I have a dax that compare current Financial Year and Previous financial year.

E.g if i want to compare one month to another, i have a problem when my current month is not a full month, maybe until the 5th of may,now i want to compare it with another previous month (same month which is may on the previous FY) but it has to calculate sales until the 10th. I have two calenders(First Calender and Comparison Date)

This is what i have sofar:

My fincial year starts July and end June

My Measures:

1st. I'ts financial year is FY23,i do have a column for that

Sales = SUM('TableA'[Sales Value])

2nd:I'ts financial year is FY22,i do have a column for that

Compare =

Var SelectedMOnth = SELECTEDVALUE('Comparison Date'[Fiscal Month Name])

Var MonthSales =CALCULATE([Sales],All('First Calender'),

USERELATIONSHIP('Comparison Date'[Date] ,'First Calender'[Date]),'Comparison Date'[Fiscal Month Name]=SelectedMOnth)

return MonthSales

The Sale measure it's from July until May 05

The Compare Measure is adding everything until June,and i want it to compare until 05.

Please see Picture Below, How do i Solve this?

Re: Compare Current and Previous Financial

DonRSA — Sun, 07 May 2023 19:23:27 GMT

Hi,anyone who can help please

topic Compare Current and Previous Financial in DAX Commands and Tips

Compare Current and Previous Financial

Re: Compare Current and Previous Financial