Forum Discussion
Memorable MemberHow to combine 2 expression into 1 ?
That's because it needs to be defined as a new calculated table, not a measure or calculated column. See the example I attached previously.
Super UserHi admin11
Try this:
Show Last 3 or 4 Yr =
VAR _Y3 =
'DATE'[Year]
>= YEAR ( TODAY () ) - 3
VAR _Y4 =
'DATE'[Year]
>= YEAR ( TODAY () ) - 4
RETURN
IF ( 'DATE'[Year] >= _Y3, 3, IF ( 'DATE'[Year] = _Y4, 4, 0 ) )
it will return 3 for the first 3 years and 4 for a year before that.
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
Memorable MemberHi VahidDM
Thank you for your sharing . i get error :-
DAX comparison operations do not support comparing values of type Integer with values of type True/False. Consider using the VALUE or FORMAT function to convert one of the values.
my PBI sample file :-
https://www.dropbox.com/s/rf7o60s9y0yhxpd/show%203%20or%204%20yr.pbix?dl=0
Hope you can take a look
Paul
- VahidDM
My bad.
Try this:
Show Last 3 or 4 Yr = VAR _Y3 = YEAR ( TODAY () ) - 3 VAR _Y4 = YEAR ( TODAY () ) - 4 RETURN IF ( 'DATE'[Year] >= _Y3, 3, IF ( 'DATE'[Year] = _Y4, 4, 0 ) )If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/- admin11
Great now no more error.
Not the situation is when i Tick box = 3 :-
it display 2019 , 2020 , 2021 , 2022
If i tick Box = 4 :-
it display 2018 only
it is possible to make it display2018 2019 , 2020 , 2021 , 2022
Hope you can share with me
Paul
it is possible to make it , when i tick box = 4 ,
- VahidDM
Can you share your file on https://wetransfer.com/ pleae?
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/