Forum Discussion
How to extract days in given format
Hi,
If I have the field Birth date like the below-given format and I need to extract days in different columns of PB how do we do?
Please Help
Hi Navnit -
Suppose, if Dateof Birth is in date format datatype, you can use
Below calculated column to find the day name and for Number below one.
Name of the Day = FORMAT(DateTable[Date],"dddd")for number format:DayN = DAY(DateTable[Date])check it and it worksDid I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!Hi Navnit
You can, from PQ transform the column to the Date data type:From this stage you can extract any aliment of date that you need
The result of some sample extractions:
The pbix is attached you can follow my steps
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
2 Replies
Hi Navnit -
Suppose, if Dateof Birth is in date format datatype, you can use
Below calculated column to find the day name and for Number below one.
Name of the Day = FORMAT(DateTable[Date],"dddd")for number format:DayN = DAY(DateTable[Date])check it and it worksDid I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!Hi Navnit
You can, from PQ transform the column to the Date data type:From this stage you can extract any aliment of date that you need
The result of some sample extractions:
The pbix is attached you can follow my steps
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.