The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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()
)
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
21 | |
20 | |
17 | |
15 | |
13 |
User | Count |
---|---|
42 | |
36 | |
25 | |
22 | |
18 |