Forum Discussion
Impossible Date Situation
I have a table with users and 2 date fields that I unpivoted to make the date fields a single date field: I then created a date table to handle these dates and created a relationship: ...
Hi Anonymous ,
You could try IF() function to judge if the result is blank. Just like there were no results in December, you could use the value of the previous month.
hi v-eachen-msft , thank you for your reply. I think I understand the gist of what you're saying! So basically convert this into a measure: "If a user no dates for the month of ____, use the previous month number."