User Profile
Kasonga2018
Frequent Visitor
Joined 7 years ago
User Widgets
Contributions
Measure to calculate penetration
Hi all I have a table that looks like this I am trying to calculate penetration by using a measure, if I have an aggregated matrix view below I would like to calculate penetration in such a way that segment A is always the denominator, so my final result should look like this.Return cycle number for every first Wednesday and third Wednesday of the month
Hi all, I need help please, I have a date table below, and I want to add a new column that will return an incremental cycle number for every first Wednesday and third Wednesday of the month. Basically for Wed, 03 Jun'20, it should return 1, for Wed, 17 Jun'20, it should return 2, then for Wed, 01 Jul'20, it should return 3 and Wed, 15 Jul'20, it should return 4 and so on. Does anyone know how I can achieve this with DAX?
