topic creating blank future dates in DAX Commands and Tips

creating blank future dates

ryanhughes — Thu, 05 Jan 2023 09:55:58 GMT

So I have a measure, thats taking a running total of the values for this fiscal year, however i need the future dates to be blank.. can anyone see what ive done wrong in my dax or have any advice for what could be wrong? Ive tried adjusting the relationships but to no avail

Re: creating blank future dates

tamerj1 — Thu, 05 Jan 2023 14:30:47 GMT

Hi ryanhughes

you mean _seldate < TODAY ( )

Re: creating blank future dates

ryanhughes — Mon, 09 Jan 2023 08:08:55 GMT

No the dates after today I want to be blank so that "if" statement needs to say IF(_seldate> TODAY(), BLANK(),...

Re: creating blank future dates

Mikelytics — Mon, 09 Jan 2023 08:59:12 GMT

Hi ryanhughes

Can you please try the following

instead of:

_seldate =SELECTEDVALUE(DimDate[Date])

please use

_seldate =MAX(DimDate[Date])

_seldate =MIN(DimDate[Date])

I assume that you Date table is on daily base and when you use SELECTEDVALUE as well as filter by month then the result of SELECTEDVALUE will be blank any time since there is more then one value behind a month.

Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.

Re: creating blank future dates

ryanhughes — Wed, 11 Jan 2023 08:14:52 GMT

Yep that worked, thanks very much!