Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Community,
I want to show the next scheduledend date (date) in one column and the due type (phone call, task, etc.) in another column.
Problem:
If I now have two different due types on the same scheduledend date, it shows me both.
Goal:
No matter which of the two due types is displayed, I would like to have only 1 due type displayed (not both).
My DAX currently (that does not work:
Next Activity Typecode =
VAR _NextActivityDate =
MIN('Aktivitäten'[scheduledend])
return
CALCULATE(
MIN('Aktivitäten'[activitytypecode_name_open]),
FILTER('Aktivitäten','Aktivitäten'[scheduledend]=_NextActivityDate)
)
Can someone help me achieve the goal?
Solved! Go to Solution.
@pbi_besi try:
Next Activity Typecode = VAR _NextActivityDate =
MIN('Aktivitäten'[scheduledend]) RETURN FIRSTNONBLANK( DISTINCT( FILTER('Aktivitäten', 'Aktivitäten'[scheduledend] = _NextActivityDate), 'Aktivitäten'[activitytypecode_name_open] ), 1 )
BBF
@BeaBF Thank you for your help.
Unfortunately, the column now shows me no values at all. Do you know what this could be?
The remaining columns are from another table...
@pbi_besi try:
Next Activity Typecode = VAR _NextActivityDate =
MIN('Aktivitäten'[scheduledend]) RETURN FIRSTNONBLANK( DISTINCT( FILTER('Aktivitäten', 'Aktivitäten'[scheduledend] = _NextActivityDate), 'Aktivitäten'[activitytypecode_name_open] ), 1 )
BBF
can you make screenshot with a full overview of the table visual?
User | Count |
---|---|
56 | |
33 | |
18 | |
17 | |
15 |
User | Count |
---|---|
94 | |
84 | |
37 | |
22 | |
20 |