Forum Discussion

Frequent Visitor

2 years ago

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...

Super User

2 years ago

Hi,

Share some data to work with and show the expected result in a Table format. Share data in a format that can be pasted in an MS Excel file. If possible, please show the column headings in English.

gsamenezes

Frequent Visitor

2 years ago

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:

Ashish_Mathur
Super User
2 years ago
Hi,

In the same_data file itself, show the formula driven result in Tab2. I will translate those Excel formulas to DAX formulas.

Forum Discussion

Problem with ticker filter

Related content

FILTERING PROBLEM

Filter problems

Problem with filters in Power Bi service

LastDate filter problem

Cross filtering problems