Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
CLAIM_HCC_ID | MEMBER_HCC_ID | SERVICE__DATE |
2017649 | 741006200-02 | 1/10/2017 |
2017649 | 748002362-01 | 1/13/2017 |
2017660 | 748006897-01 | 1/23/2017 |
2017653 | 748012926-05 | 1/13/2017 |
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
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
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