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 problem with some data that i try to analyze. My data is imported via API connection by OData feed.
The data are first of all specified in YTD values, and hereafter i have transformed it to calculate monthly values based on the YTD figures.
But, between the YTD figures and the monthly values i have a difference when i add all the monthly changes together.
On the above screenshot my total YTD should be 4.325.915, but when i add up the monthly values i get a lower figure. I have come to the conclucions that it is because of the 528.500 first being posted on June 1st, and then it stays the same YTD until August 1st, and hereafter it disappears because it is turned and therefore the YTD value is 0, but the 0 is not present in the data and therefore the monthly calculations does not get this change.
Any possible solutions to such problem? Possible to create a custom line for each 1st day in each month, and if that has no value it just returns a 0, so i get a line for each month?
Help would be appreciated!
Can you share a pbix with sample data?
|
Please accept the solution when done and consider giving a thumbs up if posts are helpful. Contact me privately for support with any larger-scale BI needs, tutoring, etc. |
So as you can see here:
I get different values based on whether i see them in YTD figures or monthly change.
For further information it is on account: 14999, companyshortname: HQ, and in year 2022.
@AlB You can see the file here: https://drive.google.com/file/d/1M4qNIIGvB-N7OEtZkSNUbQfrzvsRkKby/view?usp=sharing
Yes of course!
But i cant see how i can add the pbix file, i am new to this forum sorry.. Where do i add the pbix file in my comment?
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 |
---|---|
105 | |
105 | |
88 | |
73 | |
66 |
User | Count |
---|---|
124 | |
113 | |
98 | |
80 | |
72 |