Forum Discussion

ryanhughes's avatar
ryanhughes
Regular Visitor
3 years ago
Solved

creating blank future dates

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...
  • Mikelytics's avatar
    Mikelytics
    3 years ago

    Hi ryanhughes 

     

    Can you please try the following

     

    instead of:

     

    _seldate =SELECTEDVALUE(DimDate[Date])

     

    please use

     

    _seldate =MAX(DimDate[Date])

     

    or

     

    _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.

     

     

     

Mikelytics's avatar
Mikelytics
Resident Rockstar
3 years ago

Hi ryanhughes 

 

Can you please try the following

 

instead of:

 

_seldate =SELECTEDVALUE(DimDate[Date])

 

please use

 

_seldate =MAX(DimDate[Date])

 

or

 

_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.

 

 

 

ryanhughes's avatar
ryanhughes
Regular Visitor
3 years ago

Yep that worked, thanks very much!