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.
Dear Team,
I need help on DAX function below is my sample data
LEAD_CREATED LEAD_# LEAD_STATUS_DATE SUBMITTED_DATE SALES_ASSIGN_DATE DECISION_DATE
3/24/2024 12:41 1-6911852285 4/18/2024 18:13 3/24/2024 23:21 3/24/2024 23:14
3/24/2024 12:40 1-6911851975 3/24/2024 23:54 3/24/2024 23:04 3/24/2024 23:00
This is my sample data
here I want to create count(Lead_#)
If you see second row all dates are on 24th Mar here I want to take max date which means Lead_Status_Date is Max I want this count in Lead_Status_Date count should not repeat in other dates and this should change based on date selection
I have given relationship with lead_created but it should use userelationship with Lead_status_date same goes to all other dates.
Hope this is clear
@PowerBigginer , Not very clear
You can create a new column
Date = maxx({[LEAD_STATUS_DATE], [SUBMITTED_DATE],[SALES_ASSIGN_DATE], [DECISION_DATE]}, [Value] )
and join that with date table
Any solution for this issue ?
User | Count |
---|---|
92 | |
86 | |
66 | |
62 | |
58 |
User | Count |
---|---|
150 | |
113 | |
95 | |
80 | |
72 |