Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by attending the DP-600 session on April 23rd (pacific time), live or on-demand.
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now
I want to get total days of tx day in my table. When I write the below code, I get the error message for
"Expression.Error: 1 arguments were passed to a function which expects 3.
Details:
Pattern=
Arguments=[List]"
=List.Dates( #date("yyyy-mm-dd"), Duration.Days( Date.From( DateTime.LocalNow() ) -[#"Treatment Registrar Date#(lf)(please fill in date format: 1-Jan-2021)"]))
How can i solve for this.
Solved! Go to Solution.
the function of #date needs three parameters, such as #date(2023,10,1)
List.Dates needs a start date, end date, and interval.
---Nate
the function of #date needs three parameters, such as #date(2023,10,1)
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Experience the highlights from FabCon & SQLCon, available live and on-demand starting April 14th.
| User | Count |
|---|---|
| 5 | |
| 3 | |
| 3 | |
| 3 | |
| 2 |
| User | Count |
|---|---|
| 7 | |
| 5 | |
| 5 | |
| 5 | |
| 4 |