Forum Discussion

Abhijsrwala1's avatar
Abhijsrwala1
Frequent Visitor
4 years ago

Need Help handling Percentage

I have day of month column as text. Value as percentage. I want to calculate monthly value. what aggregation should be performed? does % average work here ?

 

 

Any dax help?

Thanks.

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Abhijsrwala1 ,

    I'm not clear about your requirement... In order to give you a suitable solution quickly, could you please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file? You can refer the following link to upload the file to the community. Thank you.

    How to upload PBI in Community

    Best Regards