Forum Discussion

bgonen7's avatar
bgonen7
Helper I
4 years ago
Solved

DAX Var for DSO

Can't get the second VAR to work - can someone help (if today's date is 8/24 then Day number should be 236)     DSO = VAR Ratio =  (([OpenAR]/[CY (YTDsales)])--this one works VAR DaysYTD = DAT...
Need Help
  • bgonen7's avatar
    bgonen7
    4 years ago

    Thanks for the quick feedback.

    I was able to simplify a bit the second VAR (also, first VAR I had to add ()

     

    DSO =
    VAR Ratio = (([Open AR]/[CY(YTDsales)]))

    VAR DaysYTD = [Days YTD]// >>>note I created a measure called [Days YTD] = DATEDIFF(DATE(YEAR(TODAY()),1,1),TODAY(),DAY)

    RETURN

    Ratio*DaysYTD

     

     

bgonen7's avatar
bgonen7
Helper I
4 years ago

Thanks for the quick feedback.

I was able to simplify a bit the second VAR (also, first VAR I had to add ()

 

DSO =
VAR Ratio = (([Open AR]/[CY(YTDsales)]))

VAR DaysYTD = [Days YTD]// >>>note I created a measure called [Days YTD] = DATEDIFF(DATE(YEAR(TODAY()),1,1),TODAY(),DAY)

RETURN

Ratio*DaysYTD