Dax calculaation for calendar number of days along with another column.

[EktaSoni_R]

Hi Team,

I want to create measure which has column installed capacity and calendar column no_of_days, but while creating measure it is asking for sum, i am unable to use no_of_days without aggregation , please help.

[FataiSanni]

It may be nice to post a sample of your Dax measure and the data stripped of any sensitive info. We may be able to assist you better

[sevenhills]

What is the error message you are getting?

Post the DAX formula.

Note, we may have to use Max or Min or Sum for a measure. Depends on your needs, we can adjust it using one of these!

[foodd]

Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot).

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.