Forum Discussion
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...
its not job related, ie not paid work i just want to build a heatmap by month to see the answers, its easier..
do you have any thoughts?
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.
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..