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
Hi @Anonymous,
>>When I try to do a % change calc referencing this measure, it comes back null.
How did you to reference this measure and which visual did you use to display that %change? Please share some sample data and desired results to clarify the issue.
Best Regards,
Qiuyun Yu
>>>.......ccv>>..
User | Count |
---|---|
103 | |
82 | |
68 | |
47 | |
46 |
User | Count |
---|---|
155 | |
91 | |
82 | |
69 | |
67 |