Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

DAX help

    Hi experts,  I need to develop below matrix with few conditions The sales amount will be depostited on the same day in case of bank working days. Otherwise they will deposit on next banking ...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    I am not sure about which dates are your holidays, but I tried to create the sample like below.

    Please check the below picture and the attached pbix file.

    All measures are in the attached pbix file with numbering the steps from 01 to 05.

    In the sample, I assigned Saturday and Sunday as holidays, but you can assign your own holidays in your calendar table, and then apply the similar logic as what are in the attached pbix file.

    I hope this helps to apply and write similar measures for your data model.

     

Jihwan_Kim's avatar
Jihwan_Kim
Super User
4 years ago

Hi,

I am not sure about which dates are your holidays, but I tried to create the sample like below.

Please check the below picture and the attached pbix file.

All measures are in the attached pbix file with numbering the steps from 01 to 05.

In the sample, I assigned Saturday and Sunday as holidays, but you can assign your own holidays in your calendar table, and then apply the similar logic as what are in the attached pbix file.

I hope this helps to apply and write similar measures for your data model.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks Jihwan_Kim , this is the exact solution I want. Thanks for your effort and time.