Forum Discussion
Soof1234
Helper I
Helper ILookupvalue combined with switch function
Hi, I created 2 dummy tables to explain my question. I would like to have a slicer with values from 'Table1'[Subscriptiontype] (Values are Yearly and Monthly) Output of measure should be the ...
Hi Soof1234 ,
You can achieve this by using sum of Price per month dircetly:
Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-jianboli-msft
Community Support
Community SupportHi Soof1234 ,
You can achieve this by using sum of Price per month dircetly:
Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.