topic Re: Changing from Today to specific Date in DAX Commands and Tips

Changing from Today to specific Date

XeperRx — Mon, 09 Mar 2020 12:52:11 GMT

Hello,

I'm new here and just beginning with Dax. I currently have formula that works well, but I'm having to make some adjustments to work with a test file. The test file data ends on January 18, 2018. Here is the formula:

Average Days to Sell = divide([Inventory Valuation (Today)],[Last 365 Days COGS Amount]) * 365

How would I write this to work with the final day being January 18, 2018 instead of (Today)?

Re: Changing from Today to specific Date

Greg_Deckler — Mon, 09 Mar 2020 12:57:28 GMT

Perhaps:

Measure =

VAR __Max = MAX('Table'[Date])

VAR __Value = LOOKUP('Table'[Inventory Value],'Table'[Date],__Max)

RETURN

divide(__Value),[Last 365 Days COGS Amount]) * 365

Difficult to be sure, Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490