Forum Discussion
ChadSmith22
4 years agoFrequent Visitor
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...
ChadSmith22
4 years agoFrequent Visitor
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
4 years agoSuper User
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