Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago

Rebuild Debt

Good morning, please need help for the following situation
v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

Hi， Syndicate_Admin ；

Sorry for the late reply, You could create column by dax, such as:

AE = IF([FECHA CO]<DATE(2020,8,1),IF([FECHA CANCEKAD]<DATE(2020,8,1),0,[IMPORTE]),0)
AF = IF([AE]>0,IF([J30]<DATE(2020,8,1),"EXPIRED","TO BE OVERCOME"),"0")

The final output is shown below:


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    4 years ago

    Thank you very much for the reply.

    In the dax programming you are putting the data "01/08/2020" as a fixed data. Precisely that data is variable according to the selected date filter

    jtur_0-1654797630205.png

    How could I program those conditions that you indicate with the data year month and calendar day?

    Thanks a lot!!