Forum Discussion
Dax Formula Returning incorrect 2019 values
Hi Experts
See attached file sample data.
Dax measure in table Year_Grp mease name _v_Prd_Act
I am trying to populate 2019 values for my products into my table but the 2019 values are aggrating somehow with my measure 2020 is fine..
If you go to table Profitability Consolidation
And filter as follows
1. Account Group = External Sales
2. Product = Diesel
3. Year = 2020 and 2019
4. Month (group) = Full
Look at channel = AFM for period 12 + 0 we have sales of 245.14 as per table visualization when we do the same for 2019 I am get 1,060.19, when the value should be 284.91..
Cannot see my error
4 Replies
- PhilipTreacy
Super User
Hi Anonymous
The PBIX file on Dropbox has been deleted.
Regards
Phil
- AnonymousNot applicable
All the file has become corrupted - trying to reproduced creat it
- manikumar34
Solution Sage
Anonymous ,
File has been deleted on Dropbox.
Can you share the measure you are using or share any data to go through .
Regards,
Manikumar
- PhilipTreacy
Super User
Anonymous
OK. Let me know when it's re-uploaded.
Cheers
Phil