Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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.
Solved! Go to Solution.
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]))
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]))
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 ?
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
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
What is the expected result here?
Thanks,
Arul
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
75 | |
64 | |
52 | |
47 |
User | Count |
---|---|
218 | |
87 | |
71 | |
63 | |
60 |