Forum Discussion

albatross19's avatar
albatross19
Frequent Visitor
5 years ago
Solved

Creating a column from a Measure

Hi everyone!   I want to be able to calculate the maximum number of calls that happen on a given day within a date range. I am using a simple      CALCULATE(COUNT(DNIS))      To obtain the ...
Need Help
Show and Tell
Tips and Tricks
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi albatross19 ，

     

    Not sure whether I have caught your meaning,see the method below:

    Create 2 columns as below:

    Related date = CALCULATE(MIN('Table (2)'[Mail Drop Date]),FILTER('Table (2)','Table (2)'[Mail Drop Date]>EARLIER('Table'[Date])))
    Date Quantity = CALCULATE(COUNT('Table'[quality call]),FILTER('Table','Table'[Related date]=EARLIER('Table (2)'[Mail Drop Date])))+0

    And you will see:

    For the related .pbix file,pls see attached.

     
    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!

     

v-kelly-msft's avatar
v-kelly-msft
Community Support
5 years ago

Hi albatross19 ，

 

Not sure whether I have caught your meaning,see the method below:

Create 2 columns as below:

Related date = CALCULATE(MIN('Table (2)'[Mail Drop Date]),FILTER('Table (2)','Table (2)'[Mail Drop Date]>EARLIER('Table'[Date])))
Date Quantity = CALCULATE(COUNT('Table'[quality call]),FILTER('Table','Table'[Related date]=EARLIER('Table (2)'[Mail Drop Date])))+0

And you will see:

For the related .pbix file,pls see attached.

 
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!

 

albatross19's avatar
albatross19
Frequent Visitor
5 years ago

v-kelly-msftThank you!

 

This looks pretty similar to the outcome I was expecting!