Forum Discussion

Cocrodile's avatar
Cocrodile
Icon for Helper I rankHelper I
4 years ago
Solved

Date blank

Hello I have this table :   Can I ask you for a function that puts me where the empty values are on the last day of that week? I would like to have the results of the 2 dates: date in  22/...
Need Help
  • Cocrodile's avatar
    Cocrodile
    4 years ago

    The solution in power query  is : 

    if [date out]=null then Date.EndOfWeek ([date in ],Day.Sunday) else [date out])

    🤣

serpiva64's avatar
serpiva64
Icon for Solution Sage rankSolution Sage
4 years ago

Hi,

You can try:

- add a custom column to your date table

- then a calculated column 

date out noblank = if(ISBLANK('Table (2)'[data out]),format(RELATED(Dates[WeekEndingSunday]),"dd/mm/yyyy"),FORMAT('Table (2)'[data out],"dd/mm/yyyy"))

If this post is useful to help you to solve your issue consider giving the post a thumbs up 

 and accepting it as a solution !