Forum Discussion

kcantor's avatar
kcantor
Community Champion
10 years ago

DAX not returning correct value

I am using a couple of very simple expressions that have worked in the past. My talbe has purchase amounts for our vendors labled as Amount. I have filtered my report to 2015 then created a measure t...
konstantinos's avatar
konstantinos
Memorable Member
10 years ago

Can you share more details like what is the filter context in the table ( nothing, rows with years, products etc). Did you create a measure or a calculated field?

kcantor's avatar
kcantor
Community Champion
10 years ago

I think there is a bug in that particular data model. I tried to snag some data to carry over and it will not refresh. It says a key does not match a table. I have not received a response from support on this issue. PowerPivot works fine with both the calculation and the data table so i may have to shelve this question for now. As soon as the data becomes accessible I will post some more information.

More context: Rows were week numbers filtered by a manufacturer code. Totals were pulled from a single column in the table and filtered by year. Have the DAX working correctly by using DateAdd - 1 year instead of SamePeriodLastYear.