Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
SamehElghazaly
Frequent Visitor

If condition isn't working with all column

Hi Guys,

Am trying below IF formula and its not working with all column , can you please advise why or how can i solve it.

"IF('Calender Test'[Quarter]="Q1","DB"&FORMAT(DATEADD('Calender Test'[Date].[Date],1,YEAR),"YY"),IF('Calender Test'[Quarter]="Q4","DB"&FORMAT(DATEADD('Calender Test'[Date].[Date],2,YEAR),"YY"),'Calender Test'[Quarter]))"

SamehElghazaly_0-1674349096919.png

 



1 ACCEPTED SOLUTION
Ashish_Mathur
Super User
Super User

Hi,

Does this calculated column formula work

=F('Calender Test'[Quarter]="Q1","DB"&YEAR('Calender Test'[Date])+1,IF('Calender Test'[Quarter]="Q4","DB"&YEAR('Calender Test'[Date])+2,'Calender Test'[Quarter]))


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

8 REPLIES 8
Ashish_Mathur
Super User
Super User

Hi,

Does this calculated column formula work

=F('Calender Test'[Quarter]="Q1","DB"&YEAR('Calender Test'[Date])+1,IF('Calender Test'[Quarter]="Q4","DB"&YEAR('Calender Test'[Date])+2,'Calender Test'[Quarter]))


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Thank you Guyes i figured it out :).

Thank you Ashish it worked but its not showin correctly in the Matrix as below.
the right arrangment asper the date should be DB2023 Q2 Q3 DB2024. any recommendation ?

SamehElghazaly_0-1674381227920.png

 

FreemanZ
Super User
Super User

hi @SamehElghazaly 

what do you get if you try like:

"IF('Calender Test'[Quarter]="Q1","DB"&FORMAT(DATEADD('Calender Test'[Date],1,YEAR),"YY"),IF('Calender Test'[Quarter]="Q4","DB"&FORMAT(DATEADD('Calender Test'[Date],2,YEAR),"YY"),'Calender Test'[Quarter]))"

same answer

jdbuchanan71
Super User
Super User

@SamehElghazaly 

I don't see anything wrong with the DAX but you don't need to use 'Calender Test'[Date].[Date], you can just use 'Calender Test'[Date].  Also, it's easier to use a SWITCH statement instead of nested IFs so it would look like this.

Internal Q =
SWITCH (
    TRUE (),
    'Calender Test'[Quarter] = "Q1", "DB" & FORMAT ( DATEADD ( 'Calender Test'[Date], 1, YEAR ), "YY" ),
    'Calender Test'[Quarter] = "Q4", "DB" & FORMAT ( DATEADD ( 'Calender Test'[Date], 2, YEAR ), "YY" ),
    'Calender Test'[Quarter]
)

What output are you trying to get?

am trying to replace all Q1 +2 row year to be shown as (1/1/2022 and Q1 to appear as DB24) in date column 

Arul
Super User
Super User

@SamehElghazaly ,

What is the expected result here?

Thanks,

Arul





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


LinkedIn


Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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