The Same week LY

[Anonymous]

Hi guys,
Can someone help Modify this DAX query

[v-chenwuz-msft]

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.

[vapid128]

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 
    )
)

[Anonymous]

@vapid128  Still return blank. 

[vapid128]

show me your sales function and relationship between tables

[Anonymous]

@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]))))

[vapid128]

I mean [sales]

[vapid128]

I tested your way, it should be work.

[Anonymous]

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