Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 :
Year | NetRev19 | NetRev23 |
2019 | 1000 | 0 |
2023 | 0 | 2000 |
Solved! Go to Solution.
Hi, @HishamAT
Based on the information you have provided, Here are my answers to your questions.
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.
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))
Proud to be a Super User!
User | Count |
---|---|
107 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |