Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi everyone,
I have this table:
I just need to get the total cost per month (from a column from another table) and place it on the "Total Cost/Month" column.
Here's the source table
and this should be the result
I'm just new to Power BI I just can't figure it out how to do it
TIA!
Solved! Go to Solution.
Hi @Anonymous,
Based on my test, you could refer to below formula:
Column = IF(CALCULATE(SUM(Table1[Cost]),FILTER('Table1','Table1'[Month]=Table2[Month Number]))<>BLANK(),CALCULATE(SUM(Table1[Cost]),FILTER('Table1','Table1'[Month]=Table2[Month Number])),0)
Result:
You could also download the pbix file to have a view.
Regards,
Daniel He
Hi @Anonymous,
Based on my test, you could refer to below formula:
Column = IF(CALCULATE(SUM(Table1[Cost]),FILTER('Table1','Table1'[Month]=Table2[Month Number]))<>BLANK(),CALCULATE(SUM(Table1[Cost]),FILTER('Table1','Table1'[Month]=Table2[Month Number])),0)
Result:
You could also download the pbix file to have a view.
Regards,
Daniel He
Hey @v-danhe-msft thanks for this! I am studying the formula so I can use it on my other files. You know where I can hae a basic tutorial or guide on the formulas? Thanks
Hi @Anonymous
Please put some sample data of the tables you have in your data model and the actual result you expect.
Cheers
CheenuSing
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |