Forum Discussion
Problem with ticker filter
I've been trying for several days to calculate the measures to determine how much a company (ticker) "contributes" to the index. For example, if an index grew by 30% in a year, how much comes from ea...
Of course, here is an Excel file with 5 days of data:
https://docs.google.com/spreadsheets/d/19Lpfi-RaovDqNgOCzi58mjzDl6YJdj5f/edit?usp=drive_link&ouid=110396506518212940461&rtpof=true&sd=true
Additionally, here is the expected result:
https://docs.google.com/spreadsheets/d/1oz8CxdVENIoDobdXbzOceM7u5tU00_MI/edit?usp=drive_link&ouid=110396506518212940461&rtpof=true&sd=true
If it helps you, this is the Python code that I used:
Hi,
In the same_data file itself, show the formula driven result in Tab2. I will translate those Excel formulas to DAX formulas.