Forum Discussion
Is Invoice Complete vs. Pending
Hey guys, So I am trying to show if an invoice is complete or pending for all lines it exists if it is either. This is based off 2 columns. Invoice number and reporting date. Above is...
Thanks! That worked. Can you explain why that date syntax messed up the formula? When I added that column it auto-populated with that info because it's a date heirarchy.
Anonymous
Power BI automatically creates one date table for each date column in the model. When you use .[Date] you refer to that table rather than the original one.
Here is a relevant article
https://www.sqlbi.com/articles/automatic-time-intelligence-in-power-bi/