Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
so simple. subtract these 2 dates, format of dates is 1/1/2020, Date type
[col1 Date] - [col2 Date] i get a duration as default output. i tried Int64.Type([col1 date] - Int64.Type([col1 date]
i get ERROR
i need todo a conditional, if > 365 etc
= Table.AddColumn(#"Filtered Rows", "New_Existing_Cust", each if Int64.Type([Quarter_Sample_Recvd]) - Int64.Type([Prev Qrt Ordered]) < 365 then "existing" else "new")
how can i just get a plain integer output !!!!!
Solved! Go to Solution.
Since it's a duration, you can use Duration.Days to convert it to an integer.
= Table.AddColumn(
#"Filtered Rows",
"New_Existing_Cust",
each
if Duration.Days([Quarter_Sample_Recvd]) - [Prev Qrt Ordered]) < 365
then "existing"
else "new"
)
Since it's a duration, you can use Duration.Days to convert it to an integer.
= Table.AddColumn(
#"Filtered Rows",
"New_Existing_Cust",
each
if Duration.Days([Quarter_Sample_Recvd]) - [Prev Qrt Ordered]) < 365
then "existing"
else "new"
)
Hi,
Int64.TypeFrom([Quarter_Sample_Recvd])
Stéphane
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.