Forum Discussion

Cotter2000

Frequent Visitor

9 years ago

Revenue by Customer & Year, Filtered Dynamically by additional field

Hi everyone, New to Dax here. I have four fields: Customer, Product Format, Price, Transaction Year For each customer AND transaction Year, I'm trying to calculate a sum of Price for any...

Need Help

GilbertQ

Super User

9 years ago

Hi there, depending on how you want to create your bands across your data, my blog post below might be able to assist to make it dynamic no matter which piece of data you choose to put it against.

https://gqbi.wordpress.com/2017/05/23/power-bi-dynamic-banding-across-all-fields/

Forum Discussion

Revenue by Customer & Year, Filtered Dynamically by additional field

Related content

Fabric Link - Dynamics Customer Insights

Copy activity dynamically populated additional columns error when using Expression values

Dynamic format seems to add additional "-" for negative values

Dynamic Filter

SIlver Layer - Additional Columns