Forum Discussion

Helper II

2 years ago

Solved

Distribute Net Revenue between 2 columns using the date

Hi How can I create a table and distribute the Net Revenue between 2 columns using the date? for example : Net Rev for the Year 2019 is 1000 Net Rev for the Year 2023 is 2000 this should be like...

Ahmedx
2 years ago
pls try htis

212.pbix21 KB

ryan_mayu

Super User

2 years ago

HishamAT

maybe you can try to create two measures

2019value = CALCULATE(sum('Table'[value]),FILTER('Table','Table'[year]=2019))

2023value = CALCULATE(sum('Table'[value]),FILTER('Table','Table'[year]=2023))

Forum Discussion

Distribute Net Revenue between 2 columns using the date

Related content

PQ -Date Distribution

Distribution Chart

Distribute Projected Revenue Annually

Normal Distribution

Distribution calculation