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.
I have a Dax filter that correctly filters to hard coded values, How can I change this to use the Filters of the current PBI visualisation page filter selection, Id also like the Date to use the SAMEPERIODLASTYEAR() for the date filter ?
What I have so far is :
previousYear = CALCULATE (
SUM ( 'vw Monthly Milk Production'[value] ),
FILTER (
All('vw Monthly Milk Production'),
'vw Monthly Milk Production'[adjustment] == "30 Day adjustment"
&& 'vw Monthly Milk Production'[Type] == "Natural Content"
&& 'vw Monthly Milk Production'[country] == "United Kingdom"
&& 'vw Monthly Milk Production'[date] == value("2020-02-01")
)
)
Ive got a bit further with below, but the sameperiod last year function, returns an empty filed in my pbi table, What Do I need to do to provide this expression with the correct context please ?
previousYear = CALCULATE (
SUM ( 'vw Monthly Milk Production'[value] ),
FILTER (
ALLSELECTED('vw Monthly Milk Production'),
'vw Monthly Milk Production'[date] == SAMEPERIODLASTYEAR(Dates[Date].[Date])
)
)
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 | |
26 | |
21 | |
16 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |