Hi All,
Bit confused about how to get this one to show up and also new to PowerBI so will need a simple explanation.
I have a table that has a job number, job stage (active, cancelled, closed, submitted), date RFP received, job name, and date of job status change (e.g when a job number changes from cancelled to active, I add the current date here)
I have created a new page as a monthly report. I need to know how many jobs have changed from submitted or any other status to ACTIVE (aka number of jobs won in the last month).
I have a number of other visuals that are affected by a date slicer. I've edited the interactions so that the JOBS WON card display isn't affected but this date slicer is based off of the DATE RFP RECEIVED.
The only logical way I can think to do this is if I count the number of jobs with the value 'active' and with the 'date of job status change' within the last calendar month.
So I created another slicer that doesn't affect anything but this one card to set the date to last calendar month but there was only 1 date as there is only one job that has changed in the last month.
Not sure how to show this number!
Many thanks
