The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello, Is anyone familiar with this error who can help? I have a simple equation:
DateDiffMOQ = DATEDIFF('MOQ Log'[Start Date],'MOQ Log'[End Date],month) - *Compares two dates, counts the months between and calculates a $ total over each month*. Simply, my 'MOQ Log' table just needs to link to my 'Date Table' and my 'Demand Seg Anchor' table.
My Error:
I do not want to link table: 'MOQ Log' with the table 'Demand Seg'. However I need to refresh 'Demand Seg' with another table called 'Demand Seg Anchor' but it stops me altogether from doing so.
How can I refresh the Demand Seg Table as well as make sure the MOQ Log[DateDiffMOQ] can be found?
Any suggestions?