topic Re: The Same week LY in DAX Commands and Tips

The Same week LY

Anonymous — Wed, 15 Jun 2022 20:46:19 GMT

Hi guys,
Can someone help Modify this DAX query

Re: The Same week LY

vapid128 — Wed, 15 Jun 2022 23:16:32 GMT

I tested your way, it should be work.

Re: The Same week LY

Anonymous — Thu, 16 Jun 2022 00:02:57 GMT

vapid128 Still not working for Weekly Sales LY. Do you have know another method?

Re: The Same week LY

vapid128 — Thu, 16 Jun 2022 00:27:37 GMT

I never use the function like your function, so I tried yours, and it works.

my function :

weekly Sales LY = var maxYear = max('Calendar'[Fiscal Year]) var maxWeekNumber = max('Calendar'[Fiscal_week_number]) return CALCULATE( [sales], filter(ALL('Calender'), 'Calendar'[Fiscal Year] = maxYear - 1 && 'Calendar'[Fiscal_week_number] = maxWeekNumber ) )

Re: The Same week LY

Anonymous — Thu, 16 Jun 2022 00:45:59 GMT

vapid128 Still return blank.

Re: The Same week LY

vapid128 — Thu, 16 Jun 2022 01:04:55 GMT

show me your sales function and relationship between tables

Re: The Same week LY

Anonymous — Thu, 16 Jun 2022 01:09:40 GMT

vapid128 My current works perfectly.

Weekly Sales CY =

CALCULATE(

[sales],

FILTER(ALL('Calendar'),

'Calendar'[Fiscal Year] = SELECTEDVALUE('Calendar'[Fiscal Year]) &&

VALUE('Calendar'[Fiscal Week])= Value(SELECTEDVALUE('Calendar'[Fiscal Week]))))

Re: The Same week LY

vapid128 — Thu, 16 Jun 2022 01:10:52 GMT

I mean [sales]

Re: The Same week LY

v-chenwuz-msft — Tue, 21 Jun 2022 07:02:49 GMT

Hi Anonymous ,

The result of SELECTEDVALUE('Calendar'[Fiscal Year]) is blank due to you only have one field in this table, so the countrows( values( 'Calendar'[Fiscal Year]) >1 of each rows when you do not do some filter outside the table visual.

Or the selectedvalue( 'Calendar'[Fiscal week number]) is blank.

If im wrong, please let me know and share your pbix file without sensitive data.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.