Forum Discussion

zxl1031's avatar
zxl1031
Icon for Helper I rankHelper I
8 years ago
Solved

Calculate dynamic average age by cuttoff date

Hello,   Thanks everyone for taking time to read my post and especially to those who are trying to provide any solution!!   Please find the pbix file here: https://drive.google.com/open?id=1EDgaP...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    8 years ago

     Hi zxl1031,

     

    The return value of "Format" function is text type, so you can't use "Format" function, you should modify your date like pattern 

    yyyy\MM\dd HH:mm:ss

    And then click Modeling-> Date type to change text type to datetime.

     

    Regards,

    Jimmy Tao

jthomson's avatar
jthomson
Icon for Solution Sage rankSolution Sage
8 years ago

How is the user selecting a cutoff date?

zxl1031's avatar
zxl1031
Icon for Helper I rankHelper I
8 years ago

Another date table was created for that.