Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi guys,
Can someone help Modify this DAX query
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.
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
)
)
show me your sales function and relationship between tables
@vapid128 My current works perfectly.
I mean [sales]
I tested your way, it should be work.
@vapid128 Still not working for Weekly Sales LY. Do you have know another method?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
25 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |