Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi , I am new on DAX and need some help here.
I need to sum the Start Date (Min date ) Amount of IDs with in a selected date range. I have tried chatGPT and it has provided me this :
Solved! Go to Solution.
@TEACHY888 , this happens when row context has been used.
Assume your current measure name is Pipeline start
create a new measure like
Sumx(Summarize( OpportunityOldValue_NewValue, OpportunityOldValue_NewValue[opportunityid],OpportunityOldValue_NewValue[changed_date], "_1", [pipeline start]) , [_1])
@TEACHY888 , this happens when row context has been used.
Assume your current measure name is Pipeline start
create a new measure like
Sumx(Summarize( OpportunityOldValue_NewValue, OpportunityOldValue_NewValue[opportunityid],OpportunityOldValue_NewValue[changed_date], "_1", [pipeline start]) , [_1])
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |