Forum Discussion
Calendar value
Does the image help? i have a table in Power Called Questions. I do capture the title, start and end dates. But now i need to see at say Jan-22 am i green or amber based on all the questions..
Hi ChadSmith22 ,
The image helped on the expected input and output but I'm still confused on the questions and its relevance to your data.
I've created a sample output for you to play around.
Here's the pbix file: https://1drv.ms/u/s!An8CCFsOzw0uhQkwdIIQEmV3Aqqt?e=DA8Uqf
thankyou - however the issue is that
question 1 - i need to report it green for jan, feb, mar
question 2 - i need to report it amber for feb to jun
(refer to above screenshot i sent)
same for question 3....
so the user enters a start and end date, and i need to populate those months with either red amber or green (or 1, 2, 3)
then i need to look at each month (say June) and figure out its color..
i hope that makes more sense 🙂 look forward to your help 🙂 🙂
Is this what you're looking for?
I've overwritten the previous version. You can use the same link.
yes !!! and then i need to rate the actual "month" also if there are no dates in the month that are relevant (a custom calendar table??) for example if i need to show next 2 years.. and Jan-23-Dec-23 has no dates or scores, then its grey... thankyou so much!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!