Forum Discussion

linros's avatar
linros
Frequent Visitor
9 years ago
Solved

Relate one column whith another colunm inside a subselect

Hi everyone!   I need to convert this query in SQL to DAX, but I need to relate one column whith another colunm inside a subselect. I tried different functions but I did not succeed.   SELECT a....
  • linros's avatar
    linros
    9 years ago

    I created a new Column and use that DAX:

     

    Variancy =
            VAR lastYear = 'Basis 1'[Year] - 1
            VAR actualYear = 'Basis 1'[Year]
    Return
            COUNTROWS(FILTER('Basis 1';'Basis 1'[Year] = actualYear))

            - COUNTROWS(FILTER('Basis 1';'Basis 1'[Year] = lastYear))

     

    That resolved my problem!

     

    Tk's dedelman_clng

    =D

linros's avatar
linros
Frequent Visitor
9 years ago

I created a new Column and use that DAX:

 

Variancy =
        VAR lastYear = 'Basis 1'[Year] - 1
        VAR actualYear = 'Basis 1'[Year]
Return
        COUNTROWS(FILTER('Basis 1';'Basis 1'[Year] = actualYear))

        - COUNTROWS(FILTER('Basis 1';'Basis 1'[Year] = lastYear))

 

That resolved my problem!

 

Tk's dedelman_clng

=D