Forum Discussion
Helper IDate Reference as parameter to determine True/False
Hi ChPetru
Solution attached.
A hint:
The dimension for products is not set correctly. This is not the way you normally set a dimension (which poses some problems right now inside PBI). Many id's have been assigned the same product name. You should have a one-to-one correspondence between the product id and the product name. There are too many reasons why this should be so, therefore I'm not going to enlarge upon this.
Nevertheless, the solution works, but please stick to proper data modeling techniques if you want to be safe in the future. Thanks.
Solution Sage
How can you aggregate active licences? There's no way to do it unless in some twisted and illogical way... A licence can be active or not at a point in time. When you say "aggregate," what do you exactly mean? You are not asking for the number of active licences but for the state of a licence. What would then be the cumulative state of several licences? There's no good way to define it in terms of "True/False."
You said:
and this is exactly what my solution does.
Helper IThe table above is just an example of the most granular level we can explore with this data, however, let's say we remove Opportunity Name from the visual. The highest aggregation will be product. Product 3 has both active and inactive licenses, so it will display <blank> in the License State (which is fine if there is conflict between active and inactive license), but if License State is only Active or only Inactive, i will still have blank, which is not ok.
Also, if I want to create a measure that considers License State, will the data that has no License State in my visual be excluded? E.G. I want to calculate revenu for the Active Products; will it exclude any data that has Inactive or Blank Status? If yes, there's a problem.
I still feel the answer to my problem is a calculated column, but not sure how I can calculate the License State using a date parameter, and how I can easily edit the parameter value in the reporting view (not Power Query).
Thank you so much for trying to help me
- daXtreme
IF you want to calculate something only for products with all licences active, then it's easy. You just find those products among all those visible in the current context and aggregate over them. That's easy. But the original question was not about aggregation. It was about showing the status (True/False) for the right granularity. That's a completely different request.
- daXtreme
IF you want to calculate something only for products with all licences active, then it's easy. You just find those products among all those visible in the current context and aggregate over them. That's easy. But the original question was not about aggregation. It was about showing the status (True/False) for the right granularity. That's a completely different request.