Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
I have the following tables:
And would love to have this table:
The "Result" table was generated based on the max date from table "Employee".
I can come up with the same result using this function:
= Table.SelectRows(#"previous step", each [ValueDate] < #date(1998, 5, 13))
Is there a way to have this formula but not using date numbers; meaning, can I change this part "#date(1998, 5, 13))" to a formula that gives my result in the following way:
1) Check max date in Table "Employee"
2) Filter Table 2 to only show anything after the Max Date?
I hope this was clear enough. Thank you in advance.
Go to Solution.
=let a=List.Max(Employee[Date of Birth]) in Table.SelectRows(PreviousStepName,each [ValueDate]>a)
View solution in original post
thank you so much!
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.