Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a card that is looking at a column value with a relative date filter, set to view the last 1 day (ignoring today). When Monday is selected, I don't want it to display the last day of Sunday. I want it to show the last day as Saturday. Someone have any idea how do that?
Hi @guilherme_gq,
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?
Regards,
Daniel He
Hi @guilherme_gq,
From your description, I could not understand the sentence "When Monday is selected, I don't want it to display the last day of Sunday. I want it to show the last day as Saturday". Could you mean the Saturday as the last day of a week? If so, you could use below formula:
Measure = WEEKDAY(LASTDATE('Table1'[Date]),3)
Result:
If I misunderstand you, could you please share some sample file and post your desired result if possible?
Regards,
Daniel He
User | Count |
---|---|
128 | |
108 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |