Hi Sam,
Yes, agree with you. The composite will help, although not at the moment at my company. We need to strictly use Direct Query. Just for the record, our ERP is Microsoft Dynamics 365 and for Power BI Embedded, it needs to be on Direct Query only.
However it’s nice to know that and many thanks for the information.
Btw, for the What-If, I’m sorry I think I overrated it, I supposed the solution is simple, just bring some simple table for the “GenerateSeries” (Range), it will works doesn’t it ?
If I’m not misunderstood the logic of What-if analysis, is that Power BI will create a table range for “factoring” so we can use it in our Measure, am I right to say that ?
Thanks,
Toni