Forum Discussion
Solved
Dax formula
Hi all,
I have data like
Date. Module qty
16/08. M1. 10
16/08. M1. 20
16/08. M2. 30
17/08. M3. 40
18/08. M4. 20
18/08. M1. 10
I need the result like
Date. Module&cards
16/08. M1-30, M2-30
17/08. M3-40
18/08. M1-10, M4-20
Please suggest a measure to achieve this.
Thanks & Regards,
Vishnu priya
I have data like
Date. Module qty
16/08. M1. 10
16/08. M1. 20
16/08. M2. 30
17/08. M3. 40
18/08. M4. 20
18/08. M1. 10
I need the result like
Date. Module&cards
16/08. M1-30, M2-30
17/08. M3-40
18/08. M1-10, M4-20
Please suggest a measure to achieve this.
Thanks & Regards,
Vishnu priya
Hi AnilKumar,
You can create a measure below:
Module&cards = var t=SUMMARIZE('Table','Table'[Date],'Table'[Module],"total",SUM('Table'[qty]))returnCONCATENATEX(t,'Table'[Module]& "-"&[total],",")Best Regards,
Qiuyun Yu
1 Reply
Hi AnilKumar,
You can create a measure below:
Module&cards = var t=SUMMARIZE('Table','Table'[Date],'Table'[Module],"total",SUM('Table'[qty]))returnCONCATENATEX(t,'Table'[Module]& "-"&[total],",")Best Regards,
Qiuyun Yu