topic Re: DAX for last financial year total to be a fixed number in DAX Commands and Tips

DAX for last financial year total to be a fixed number

brightlight — Mon, 06 Feb 2023 06:27:45 GMT

Dear community,
I have a fact table like the following:

Need a DAX to calculate Total of the Full Last Financial Year (July 2021 - June 2022), and make that number as a static one without being sliced in other tables, for example:

Thank you!

Re: DAX for last financial year total to be a fixed number

Greg_Deckler — Mon, 06 Feb 2023 03:55:15 GMT

brightlight Probably should unpivot the date columns. Also, what does your date table look like?

Re: DAX for last financial year total to be a fixed number

brightlight — Mon, 06 Feb 2023 04:07:31 GMT

Greg_Deckler The raw data is the ERP system connected through SQL server, so the layout of date column is not relevant perhaps? Date table is created with CALENDARAUTO. Already have the Qty measure in place being SUMX('Fact Table','Fact Table'[Qty])

Re: DAX for last financial year total to be a fixed number

Greg_Deckler — Mon, 06 Feb 2023 12:53:38 GMT

brightlight Do you have a Fiscal Year column in your Date table?

Re: DAX for last financial year total to be a fixed number

brightlight — Mon, 06 Feb 2023 22:28:54 GMT

Greg_Deckler Yes I do have the fiscal year column in Date table, see below: