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 All,
I have a data set Having same values except date column
Ex:
ID changed date category
1 1/3/2020 Bike
1 3/3/2020 Bike
2 3/3/2020 car
2 4/3/2020 car
In this I want the out put as
ID changed date category
1 3/3/2020 Bike
2 4/3/2020 car
How can I achieve it
Please help
Solved! Go to Solution.
Hi @chandraismoon ,
Try to create a measure for date column:
Max_date =
CALCULATE(
MAX([changed date]),
ALLEXCEPT(
'Sheet1 (2)',
'Sheet1 (2)'[ID], 'Sheet1 (2)'[category]
)
)
Finally, you can change the data format
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @chandraismoon ,
Try to create a measure for date column:
Max_date =
CALCULATE(
MAX([changed date]),
ALLEXCEPT(
'Sheet1 (2)',
'Sheet1 (2)'[ID], 'Sheet1 (2)'[category]
)
)
Finally, you can change the data format
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi chandraismoon,
We can write the DAX function to get the max date by grouping the categories.
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
69 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |