Forum Discussion

Avivek's avatar
Avivek
Icon for Post Partisan rankPost Partisan
5 years ago

Need help with the DAX

I am trying to create a measure with the following logic, If last 1 completed month and the current month is selected then show the Total Exp. Usage Projected for only current month, if last 2 month...
Need Help
Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
5 years ago

Hi Avivek ,

 

Share some input data and the expected output as a sample so that it can be tried at our end.

 

Thanks,

Pragati

Avivek's avatar
Avivek
Icon for Post Partisan rankPost Partisan
5 years ago

Pragati11 ,

I tried to illustrate an example, please let me know if this helps

 

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi Avivek ,

     

    It can be done, but we really need your sample data for reference. Would you please inform us more detailed information( your sample data and expected output (by OneDrive for Business)) if possible? Then we will help you more correctly.

     

    Please do mask sensitive data before uploading.

     

    Thanks for your understanding and support.

     

    Best Regards,

    Dedmon Dai