top of page
Search

๐๐จ๐ฐ๐ž๐ซ ๐๐ˆ ๐š๐ง๐ ๐„๐ฑ๐œ๐ž๐ฅ - ๐ƒ๐š๐ญ๐ž ๐“๐ข๐ฉ - 23 Feb 2022

๐…๐ข๐ง๐๐ข๐ง๐  ๐ƒ๐š๐ญ๐ž ๐Ÿ๐ซ๐จ๐ฆ ๐ƒ๐š๐ฒ ๐จ๐Ÿ ๐ญ๐ก๐ž ๐˜๐ž๐š๐ซ ๐ข๐ง ๐„๐ฑ๐œ๐ž๐ฅ ๐ฐ๐ข๐ญ๐ก ๐…๐จ๐ซ๐ฆ๐ฎ๐ฅ๐š & ๐ข๐ง ๐๐จ๐ฐ๐ž๐ซ ๐๐ˆ ๐ฎ๐ฌ๐ข๐ง๐  ๐ƒ๐€๐—

Imagine you have only Day of the Year in your Data and out of that if you wish to create

a complete Date, then this formula is useful !!


Excel - Add 54 in Cell A2 ( Why 54 , this is the Day of year on 23 Feb 2022)

in Cell B2 use this formula

๐ƒ๐€๐“๐„(๐˜๐„๐€๐‘(๐“๐Ž๐ƒ๐€๐˜()),๐Œ๐Ž๐๐“๐‡(๐“๐Ž๐ƒ๐€๐˜())-๐Ÿ,๐€๐Ÿ)

You will get the result as Today's Date


Power BI - Create a New Column and the DAX will be

(Lets assume the name of the existing Column containing Day of Year is [Day of Year])

๐‘๐ž๐ช๐ฎ๐ข๐ซ๐ž๐ ๐ƒ๐š๐ญ๐ž = ๐ƒ๐€๐“๐„(๐˜๐„๐€๐‘(๐“๐Ž๐ƒ๐€๐˜()),๐Œ๐Ž๐๐“๐‡(๐“๐Ž๐ƒ๐€๐˜())-๐Ÿ, [๐ƒ๐š๐ฒ ๐จ๐Ÿ ๐˜๐ž๐š๐ซ])

the new calculated column Shows respective Date

4 views0 comments
bottom of page