Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I need a button that if you click on it, it will filter everything by the current day. I need to put this in a slicer so i can filter everything by it.
Does anyone know how todo this.
Currentday = IF(DAY(TODAY())=DAY(ValueEntries[Document_Date].[Date]),1,0)
This is what I have but it does not seem to work.
Thank you.
Hey @lucpaymetals
You need create a COLUMN in your table, and not a measure.
Current Day = IF(ValueEntries[Document_Date] = TODAY(), 1,0)
If this post helps, please mark as solved to help other users find quickly in our community!
Regards,
Marcel
Regards,
Marcel Magalhães
Microsoft Power BI Official Partner
MCT | Certified PL-300 Power BI
User | Count |
---|---|
84 | |
77 | |
72 | |
70 | |
55 |
User | Count |
---|---|
107 | |
98 | |
86 | |
79 | |
67 |