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.
[Admit Less Start] [UniqueID]
39 001692581March62018
65 001692581February82018
73 001692581January312018
85 001692581January192018
1 001692581January312018
13 001692581January192018
4 001692581January192018
I am brand new to Power BI and have a question:
What is the best way to get this answer?
Solved! Go to Solution.
@MPfeifer Please try to group the data by UniqueID and select the Minimum "Admit Less Start" either in DAX or Power Query.
In DAX, create a "New Table" as below
Test60Out = SUMMARIZECOLUMNS(Test60Group[UniqueID],"AdmitLessStart",MIN(Test60Group[AdmitLessStart]))
Proud to be a PBI Community Champion
@MPfeifer Please try to group the data by UniqueID and select the Minimum "Admit Less Start" either in DAX or Power Query.
In DAX, create a "New Table" as below
Test60Out = SUMMARIZECOLUMNS(Test60Group[UniqueID],"AdmitLessStart",MIN(Test60Group[AdmitLessStart]))
Proud to be a PBI Community Champion