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

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!