Skip to main content
Community site session details

Community site session details

Session Id : C3PyBuz0KcBCXPRR4Ar9st
Power Apps - Power Query
Unanswered

Custom Column - combine two query function

Like (0) ShareShare
ReportReport
Posted on 20 Jul 2023 11:45:03 by 2

Hi,

I have a standard date column named "MyDate"

I want to create a custom column with year + quarter number,  like: 2023 Q1

If I use this, it is working well: Date.Year([MyDate])  I am getting year number in my "MyQuarter"  column

this is also fine: Date.QuarterOfYear([MyDate])       again  I am getting quarter number in my "MyQuarter"  column

but the combination not: 

Date.Year([MyDate]) & " Q" & Date.QuarterOfYear([MyDate])

where I am doing a mistake

Thank you for your help

  • DavidWass Profile Picture
    2 on 20 Jul 2023 at 14:21:36
    Re: Custom Column - combine two query function

    Hi AlienSx,
    Thank you very much !!

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410 Super User 2025 Season 2

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2

Featured topics

Loading complete