Forum Discussion

meski's avatar
meski
Frequent Visitor
8 years ago
Solved

Aggregating measure based on dates

Hi   I am working with invoice level data but am trying to create a measure which applies conditions at the aggregated customer level within a period. Example below shows invoice $ by customer and ...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    If you look at the PBIX file I loaded, I add both.

     

    The first is a calculated column to the 4 column table

     

    Within Terms = IF('Table1'[Overdue]=0,"Y","N")

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

I think I have it,

 

This basic measure sounds like it does the trick. I have attached a sample PBIX

 

Measure = MIN('Table1'[Within Terms])

meski's avatar
meski
Frequent Visitor
8 years ago

Hi Phil - apologies, I haven't been clear.  The last 2 cols in my example are not in the source data.  The boxed column ('Within Terms @ customer level') is the result I am trying to get whereas the column 'Within Terms' is the result I am getting at present. Thx again.

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    8 years ago

    If you look at the PBIX file I loaded, I add both.

     

    The first is a calculated column to the 4 column table

     

    Within Terms = IF('Table1'[Overdue]=0,"Y","N")

    • meski's avatar
      meski
      Frequent Visitor
      8 years ago

      Thanks Phil - works well.  Am npw trying to get a count of how many customers meet this criteria within a period or within a division which I can do but am having issues with getting the count to work at Grand Total level.  In this eg the total should be 1 (ie Cust B). Thanks again in advance.