Hello Eveyone!
I have this business rule that I have two measures on sales.
I have the " month partial sales report", that everyone has access during the current month. And I have the "full sales report", and this one should be announced just in the last 2 working days of the current month.
My calendar table is already set to mark the last 2 'working' days and I have this mark in a calculated column (in DAX). It marks perfectly the days that I would announce the full sales report.
I would like it to work as an alarm, showing all the "full sales report", just when reaching the marked day in the Calendar.
I tried to create another calculated column on the calendar table, a condition that mark all days in the current month as "locked" and, when reaching the day marked to show, the condition turns to "unlocked". But did not succed on it.
Is there any way to make this kind of filter without creating another DAX measure ?
Thanks!
