I apologize if this has already been answered. I could not find a similar issue or resolution.
I am running the March 2017 release of Powerbi Desktop.
We have a custom date calendar. To that end, I have created a separate date table (Fiscal_Calendar_Daily) , one row for each date. I also have a column in this table called week ending date which has the last day of the fiscal week.
I have built some prior week sales measure(s) and they work perfectly in a table in Powerbi. Here is the calc for prior week
Total Net Sales PW = CALCULATE([Total Net Sales], FILTER(ALL(Fiscal_Calendar_Daily[WeekEndingDate]), Fiscal_Calendar_Daily[WeekEndingDate] = max(Fiscal_Calendar_Daily[WeekEndingDate])-7))
When I try to do a % change calc referencing this measure, it comes back null. When I simply pull in this measure to a table visualization , it works perfectly. I have filters (slicers) to select the appropriate fiscal year and fiscal week.
I have never had this situation where a measure could not be referenced into another measure. I must have something wrong, but not sure what the issue is.
Thanks very much.
Pete
