Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am trying to do the following calculation.
I have a MasterCalender starting from field name 'datum'= 01.01.2000 - today()+10 years this is my dimension date(datum,'MMM.YY')
My Table data
Task | Status20 | Status50 |
8800123 | 10.12.2020 | 22.12.2020 |
8800124 | 09.10.2020 | 19.11.2020 |
8800124 | 09.10.2020 | 19.11.2020 |
8800125 | 17.11.2020 | 20.11.2020 |
8800125 | 17.11.2020 | 20.11.2020 |
I want to show how many Tasks (distinct) were in each month in Status 20 and Status50. Similiar to this
So far I have no clue how to include the Status20 or Status50 in my expression.
Thank you in advance
PFA
I tried it in a similar way but it gives me always the same amount in each month whether for Status20 or Status50
Have you restricted Flag based on measure?