Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I am brand new to DAX. In one of my lessons I was told to enter an IF statement:
Solved! Go to Solution.
Hello @revisr,
If statement syntax is IF(<logical_test>, <value_if_true>[, <value_if_false>])
IF function (DAX) - DAX | Microsoft Learn
Therefore, you code should be like this:
IF(
FORMAT('Customer'[Birth Date], "mmdd") <= FORMAT(TODAY(), "mmdd"),
DATEDIFF('Customer'[Birth Date], TODAY(), YEAR),
IF(
FORMAT('Customer'[Birth Date], "mmdd") > FORMAT(TODAY(), "mmdd"),
DATEDIFF('Customer'[Birth Date], TODAY(), YEAR),
1
)
)
Kind Regards,
Gökberk Uzuntaş
📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!
🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |
That did it thanks!!
Hi revisr,
Looks like the formula @uzuntasgokberk provided was unnecessarily complex. You were on the right track with your original measure. You just had an extra comma in your measure, before the -1 at the end. The comma made Power BI think the -1 was a fourth argument in your IF function. Hopefully that makes sense.
You had:
IF (
FORMAT ( 'Customer'[Birth Date], "mmdd" ) <= FORMAT ( TODAY(), "mmdd" ),
DATEDIFF ( 'Customer'[Birth Date], TODAY(), YEAR ),
DATEDIFF ( 'Customer'[Birth Date], TODAY(), YEAR ), - 1
)
However, what you meant was:
IF (
FORMAT ( 'Customer'[Birth Date], "mmdd" ) <= FORMAT ( TODAY(), "mmdd" ),
DATEDIFF ( 'Customer'[Birth Date], TODAY(), YEAR ),
DATEDIFF ( 'Customer'[Birth Date], TODAY(), YEAR ) - 1
)
Proud to be a Super User! | |
Hello @revisr,
If statement syntax is IF(<logical_test>, <value_if_true>[, <value_if_false>])
IF function (DAX) - DAX | Microsoft Learn
Therefore, you code should be like this:
IF(
FORMAT('Customer'[Birth Date], "mmdd") <= FORMAT(TODAY(), "mmdd"),
DATEDIFF('Customer'[Birth Date], TODAY(), YEAR),
IF(
FORMAT('Customer'[Birth Date], "mmdd") > FORMAT(TODAY(), "mmdd"),
DATEDIFF('Customer'[Birth Date], TODAY(), YEAR),
1
)
)
Kind Regards,
Gökberk Uzuntaş
📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!
🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
27 | |
13 | |
11 | |
9 | |
6 |