'Power BI: How to get sum of YTD value not YTD of SUMS
I have financial data from various companies. For company A data is provided as YTD values, for company B data is provided as monthly values. This can be seeen in the value column. I wrote the following to get values from both companies on the same standard i.e. YTD format.
Value_YTD = IF( MAX(IS_consolidated[Company]) in {"Company B"}, TOTALYTD( SUM(IS_consolidated[Value]), 'Date'[Date]),SUM(IS_consolidated[Value]) ) I then want to drill up the Value_YTD for company A and company B. When I do, the "drilled up" value is a YTD of the sums. This is not what I want. What I want is a sum of the YTD. Can someone help please? I have also illustrated the problem and desired result in the picture following.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|