CODEWITHSUNDEEP
powerbidax
Jonas
Jonas

Reputation: 59

Dax - How to get the max value from a column compare with Selected date and row by row

My Dax dont work..

ERROR: A single value for column 'Datum' in table 'tabell' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.

Q: How to i get the desired values from my dax to get the latest date? I want it to return the newst date but if its older then the selected values i want it to return that value. I have done a dax but you see the error above. I want every row to return the Datum or the selected values depedning on the logic.

Selected values '2022-09-01'

desired value = MAX('tabell'[Datum],selectedvalue(vwdatum[datum].[date]))

Datum         desired value
2020-09-25    2020-09-25
2020-09-22    2020-09-25
2020-01-02    2020-09-01

alternativ

IF('tabell'[Datum]>selectedvalue(vwdatum[datum].[date]),'tabell'[Datum],selectedvalue(vwdatum[datum].[date])

Upvotes: 0

Views: 1804

Answers (1)

Ozan Sen
Ozan Sen

Reputation: 2615

Maybe It is much better to create a calculated column, and use this DAX code to evaluate it on a row_by_row basis:

Just write your selected date value into the variable:

Desired Value =
VAR SelectedValue =
    DATE ( 2020, 09, 01 )
RETURN
    IF ( Tabell[Datum] > SelectedValue, MAX ( Tabell[Datum] ), SelectedValue )

If we test it, It gives us:

GERDDFGH

SelectedEnd Code For @Jonas

SelectedEnd =
VAR aret =
    SELECTEDVALUE ( 'vwDimDatum2 Slut'[År],2020 )
VAR manad =
    SELECTEDVALUE ( 'vwDimDatum2 Slut'[Månad nr], 01 )
VAR datumet =
    DATE ( aret, manad, 01 )
VAR sista =
    EOMONTH ( datumet, 0 )
RETURN
    sista

Upvotes: 0

Related Questions