Forum Discussion

Shelley's avatar
Shelley
Icon for Post Prodigy rankPost Prodigy
9 years ago

DATESBETWEEN is Running Past Current Date

I'm hoping I'm just missing something simple. I'm struggling to figure out how to do what I want.   I am trying to calculate Machine Downtime within a 90 Day rolling window. In other words, I want ...
Need Help
TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
9 years ago

Hey,

 

maybe it would be helpful to use

LASTNONBLANK('Daily Calendar'[Date], SUM('FactTable'[column]))

this would return the last date from your facttable

 

Hope this may help