cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Post Partisan

## How to days count of number in days

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

1 ACCEPTED SOLUTION
Super User

@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()
)``````

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
4 REPLIES 4
Post Partisan

@Greg_Deckler   ya  i want to apply  above formula only for three overdue  types only ..Thanks Now working

Super User

@THENNA_41 Try:

``````OSS date column =
IF(ISBLANK([Proposedate]),[Delivery]+VALUE([Timeconv]),[Proposedate]+VALUE([Timeconv]))``````

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
Post Partisan

@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

Super User

@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()
)``````

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors