Today is 9/20/2023. I'd like to create a measure that would show All dates thru yesterday. I.E. 1/1, 1/2 ... 9/18, 9/19. It would always reference what today is and show all dates thru yesterday.
Hi @Del235 your cal. table could be
Did I answer your question? Kudos appreciated / accept solution!
Error appears but the table is created as Test. The table shows every date in 2023 but it doesn't stop at 9/20, which would have been yesterday. Which field should I be using?
I have a Date table. The formula is now
Hi @Del235 I wrote you solution as new calculated table, not column.
Do you need column in your Date table to mark somehow dates in current year less than yesterday?
Measure is usually something which is aggregrable, like sum, min...
When you wrote all the dates up to yesterday, you mean table with all dates in ths year up to yesterday? Or...
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.