Forum Discussion

ChadSmith22's avatar
ChadSmith22
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...
Need Help
hnguy71's avatar
hnguy71
Super User
4 years ago

Hi ChadSmith22 ,

 

You would likely need to build two disconnected dimension tables, one for your dates and one for your choices. You'll also need to build fact table that captures the user inputs.

 

Honestly, it's a bit hard to visualize the requirement without understanding the full picture of the problem statement.

ChadSmith22's avatar
ChadSmith22
Frequent Visitor
4 years ago

  • ChadSmith22's avatar
    ChadSmith22
    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..

      • ChadSmith22's avatar
        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 🙂 🙂