I have rows of invoices, so lets say for 1 customer there are 4 invoices with a text description:
1. Standard module 12. Premium module 1
3. Standard module 2
4. Premium module 2
I want to check whether in the current month a customer has at least one premium module. IF so, then the client is a premium client this month. So I need the check this for every client in one month.
I am a bit stuck because dynamic segmentation only looks at numbers, not at text. Could anyone give a hint?
Go to Solution.
You can use below measure to check premium status.
Is premium =
CONCATENATEX ( ALLSELECTED ( Table1[Module] ), [Module], "," ),
View solution in original post
Thanks I managed to solve it this way:
Can you please share some sample data? I'm not so clarify for your data structure.
So for every month and every customer the formula needs to check if there is at least one invoice with a "premium" module.
Thanks for your help already.
In this file you can see the desired outcome and sample data.
So for every month & customer I need to check whether at least 1 Premium Module was invoiced...
Check out the on demand sessions that are available now!
Check out the Winners!
Features releasing from October 2020 through March 2021