Forum Discussion

Frequent Visitor

4 years ago

Calendar value

Hi Everyone, I have a report that i need to create. i have an excel file with a series of questions. Example: Question 1: Enter the duration of the challenge. User chooses two date field...

Frequent Visitor

4 years ago

Frequent Visitor

4 years ago

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..

hnguy71
Super User
4 years ago
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
- ChadSmith22
  Frequent Visitor
  4 years ago
  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 🙂 🙂
  - hnguy71
    Super User
    4 years ago
    ChadSmith22 ,
    
    Is this what you're looking for?
    
    I've overwritten the previous version. You can use the same link.

Related content