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 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.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
92 | |
83 | |
62 | |
61 | |
58 |
User | Count |
---|---|
157 | |
118 | |
103 | |
76 | |
66 |