Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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()
)
User | Count |
---|---|
20 | |
14 | |
11 | |
8 | |
6 |
User | Count |
---|---|
23 | |
23 | |
20 | |
15 | |
10 |