Forum Discussion

prabinnepak's avatar
prabinnepak
Regular Visitor
8 years ago

Aggregation on top of summarize function

  Hi All, I have a dataset where i just need to calculate the max and min of a particular service data for a certain member and a claim  and need to calculate an aggregate on top   Sample data  ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi prabinnepak,

 

According to your formula, I'm not so sure why you try to get sum of date value. Can you explain more about this?


In addition, if you want to get the grouped min/max date and diff between them, you can try to use below formula to create new table with above data.

edsummarized =
ADDCOLUMNS (
    SUMMARIZE (
        'Reports vw_Health_Services_utilization',
        'Reports vw_Health_Services_utilization'[CLAIM_HCC_ID],
        'Reports vw_Health_Services_utilization'[MEMBER_HCC_ID],
        "MIN", MIN ( 'Reports vw_Health_Services_utilization'[MIN_SERVICE_START_DATE].[Date] ),
        "MAX", MAX ( 'Reports vw_Health_Services_utilization'[MAX_SERVICE_END_DATE].[Date] )
    ),
    "Diff", DATEDIFF ( [MIN], [MAX], DAY )
)

 

Regards,

Xiaoxin Sheng

  • prabinnepak's avatar
    prabinnepak
    Regular Visitor
    8 years ago

    Hi

    Thanks for your feedback

    After executing this formula I am getting the following error 

     

    "The expression refers to multiple columns.Multiple columns cannot be converted to a scalar value "

     

    Thanks and Regards

    Prabin Nepak  

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi prabinnepak,

       

      >>"The expression refers to multiple columns.Multiple columns cannot be converted to a scalar value "

      Above formula is calculated table formula, you can't use this formula in calculated column/measure.

       

      Regards,

      Xiaoxin Sheng