Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
i have three column Deilviery date ,proposedate ,Timecov. i want to TImecov number to propose date . if any blank row in porposedate its take delivery date column
Delivery Proposedate Timecov
15 sep 2019 10 sep 2019 7
16 sep 2019 10 sep 2019 7
05 june 2020 30
15 July 2019 10 sep 2020 45
15 sep 2019 10 sep 2021 21
Output:
Delivery Proposedate Timecov OSS date
15 sep 2019 10 sep 2019 7 17-sep-2019
16 sep 2019 10 sep 2019 7 17-sep-2019
05 june 2020 30 05 july 2020
15 July 2019 10 sep 2020 45 25 oct 2020
15 sep 2019 10 sep 2021 20 30 sep 2021
any idea.its possible in dax ? i am looking for support . i am tired DATEADD fucntion i am getting Error
Thanks
Solved! Go to Solution.
@THENNA_41 If I understand correctly, then something like:
OSS date column =
IF([Overdue] = "Standard overdue" || [Overdue] = "Old overdue" || [Overdue] = "UrgentOverdue",
IF(ISBLANK([Proposedate]),[Delivery]+VALUE([Timeconv]),[Proposedate]+VALUE([Timeconv])),
BLANK()
)
@Greg_Deckler ya i want to apply above formula only for three overdue types only ..Thanks Now working
@THENNA_41 Try:
OSS date column =
IF(ISBLANK([Proposedate]),[Delivery]+VALUE([Timeconv]),[Proposedate]+VALUE([Timeconv]))
@Greg_Deckler its working perfect thanks . how i will filter on this above query
i have Overdue column name
Overdue
Close Po
Standard overdue
Old overdue
UrgentOverdue
Purchase OVR
i want above apply only Standard overdue ,Old overdue ,UrgentOverdue . please how i will this filter above query
@THENNA_41 If I understand correctly, then something like:
OSS date column =
IF([Overdue] = "Standard overdue" || [Overdue] = "Old overdue" || [Overdue] = "UrgentOverdue",
IF(ISBLANK([Proposedate]),[Delivery]+VALUE([Timeconv]),[Proposedate]+VALUE([Timeconv])),
BLANK()
)
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.