Forum Discussion
Solved
Calculating a sum column based on two other columns using a filter
Hi Everyone, I'm trying to create a new column using DAX which sums two other columns using a filter for every month. I have a table which looks like the following: For each month, the c...
Hi Ashish_Mathur ,
I have tried a bunch of different measures but to no avail. I'm guessing its got something to do with the data model?
Here's a link to the test file: https://drive.google.com/file/d/1__IMIyQ1TU9Zo2D8U5iY4EQd8RPYzNgC/view?usp=sharing
Any ideas will be super helpful! Thank you!
OMG Ashish_Mathur, you genius! worked like a charm! Always saving the day! Thank you so much!
You are welcome. Thank you for your kind words.