Forum Discussion
Memorable MemberYTD expression less one month
Hi admin11
YTD Less one Month column is a Flag, please try to build it in your Date table.
In your sample , you build it in another table instead of Date table, so you will get the wrong result.
You table should look like as below. YTD Less one Month column in Jan and Feb in 2021 will return 1 and Mar will return 0.
Result is as below.
By default:
Select 1, it will show Jan and Feb in 2021.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Memorable MemberAnonymous
I have try , i get Jan till DEc 2021. what i expect is getting only Jan till Feb 2021 not include March 2021.
Hi admin11
YTD Less one Month column is a Flag, please try to build it in your Date table.
In your sample , you build it in another table instead of Date table, so you will get the wrong result.
You table should look like as below. YTD Less one Month column in Jan and Feb in 2021 will return 1 and Mar will return 0.
Result is as below.
By default:
Select 1, it will show Jan and Feb in 2021.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.