Forum Discussion
admin11
Memorable Member
Memorable MemberHow to combine 2 expression into 1 ?
Hi All I have below 2 seperate expression :- Show Last 3 Yr = IF ('DATE'[Year] >= Year(TODAY()) - 3, 1, 0) Show Last 4 Yr = IF ('DATE'[Year] >= Year(TODAY()) - 4, 1, 0) May i know how...
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.
admin11Memorable Member
Memorable Member
Thank you for your help , i get below error :-
A table of multiple values was supplied where a single value was expected.
https://www.dropbox.com/s/ax5w2w8ygxzzw8h/PBS_VER0351.pbix?dl=0
Above link is my PBI
Paul
AlexisOlson
Super User
Super UserThat's because it needs to be defined as a new calculated table, not a measure or calculated column. See the example I attached previously.
- admin11
many thank