Forum Discussion
2 different datasets, If condition
Hello, I have 2 datasets, an old one and a new one. I need to sum until the 31rd December the rows from the old one and from 1st January on, the rows from the new one. The problem is that the old...
Jihwan_Kim
Super User
Super UserHi, Anonymous
Please try the below.
newmeasure =
IF (
SELECTEDVALUE ( [datecolumnfromdatetable] ) >= DATE ( 2021, 1, 1 ),
SUM ( [newtablecolumn] ),
SUM ( [oldtablecolumn] )
)
Or, please share your sample pbix file's link here, then I can try to look into it to come up with a more accurate measure.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM