Forum Discussion

HishamAT's avatar
HishamAT
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 this table  : 

YearNetRev19NetRev23
201910000
202302000

 

Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

3 Replies

  • ryan_mayu's avatar
    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))

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi, HishamAT 

    Based on the information you have provided, Here are my answers to your questions.

    1. Generating a table with Year and Rev.

     

    1. Create a Net Revenue, Rev and Measure to integrate them with the table above to get the results you want.

     

     

    How to Get Your Question Answered Quickly 

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

    Best Regards

    Yilong Zhou

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.