Forum Discussion

ToNo87's avatar
ToNo87
Regular Visitor
9 years ago
Solved

Get value from a field based on another field

I have a table something like this   Value | Datetime (date) 2          12/12/2016 3          12/12/2016 2          12/12/2016 2          12/12/2016 4          12/12/2016 2          12/14/201...
  • PavelR's avatar
    PavelR
    9 years ago

    Hi ToNo87

     

    create measure like

    Distinctcount M-1 = CALCULATE(DISTINCTCOUNT(Table1[Value]);DATEADD(Table1[Date];-1;MONTH))

     

    Regrds.

    Pavel

ToNo87's avatar
ToNo87
Regular Visitor
9 years ago

Thanks PavelR

 

This is the error message I got:

The syntax for ';' is incorrect. (DAX(CALCULATE(DISTINCTCOUNT(Data[Value]);DATEADD(Data[Time];-1;MONTH)))).

 

this is the measure I added:

Distinctcount -1 = CALCULATE(DISTINCTCOUNT(Data[Value]);DATEADD(Data[Time];-1;MONTH))

 

Note that Data[Value] is hash id (text) and Data[Time] is date/time if that matters.

Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
9 years ago

ToNo87

 

Try replacing ; by ,

  • ToNo87's avatar
    ToNo87
    Regular Visitor
    9 years ago

    It worked, thanks!