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
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