Forum Discussion

Rngomoa's avatar
Rngomoa
Frequent Visitor
3 years ago
Solved

Using dateadd with Max

Am trying to create a Dax to select cases within the defined date period as follows. However, when remove the curdate2, am able to view some results but when i use curdate2, there is not result. I ho...
  • andhiii079845's avatar
    andhiii079845
    3 years ago

    The probem is that you use a column in this DAX expression:
    You need to use something like SELECTEDVALUE(CalenderDate[dates]) or VALUES or MAXX i think.
     curdate2=DATEADD(CalenderDate[dates],-28,DAY)

andhiii079845's avatar
andhiii079845
Solution Sage
3 years ago

Can you please show, how you use the the measure? In a matrix? With which columns?