Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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)
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 19 | |
| 9 | |
| 8 | |
| 7 | |
| 6 |