Forum Discussion

MarkCBB's avatar
MarkCBB
Helper V
9 years ago

DAX relevent date

Hi there,   I created the below Measure, for use in a KPI visual, the problem is the TODAY() part, the today needs to be relevent to the point of time.   KPI Phantom Stock = DIVIDE( CALCULATE(C...
Need Help
EAfang's avatar
EAfang
Frequent Visitor
9 years ago

Your explanation is not all that clear. Would be better if you provide a sample data uploaded in OneDrive or Google Drive so one can write the measure for you accurately. But some thoughts;

 

1. You do not really need the TODAY() function to get the most recent [non-zero] value. If your Calendar table is dates starts and ends same day as the Sale Table dates, then filter directly from Calendar wrapped in an IF([measure] <> BLANK()). Else filter Sales table dates directly with say VALUES(Sales[Date]).

2. Easier to write a smaller measure like 

[Total Sales] = COUNTROWS(SALES)

then reuse it on other measures.

 

Cheers