Forum Discussion
Need help with creating a dynamic column in Power BI
Resident RockstarHi, it is hard to follow what you would like to achieve. Can you post the sample data and the output you want versus what you get? May be field parameters can help.
I have data organized in several columns, such as:
- Dates
- Search terms
- Clicks
- ACOS
- Daily sales
When I add a column with a formula, the result is incorrect when I filter by a date range, because the formula performs daily calculations instead of totals for the selected date range and search term in the filter. In the attached image, you can see that when I filter for the search term "plantillas de gel mujer" in a certain date range, the matrix shows correct results for the selected date range as "Profitable**", but in the filter, it shows "Profitable" and "Untested", which is incorrect as it should only display "Profitable**".
Clearly, I have a measure in the matrix and the column with the aforementioned formula in the filters.
Therefore, I am not sure how to get it to display the correct result.