How to create crop season with dates, and different calculations?

[Anmolgan]

Hi I want to create a season data with crop, there are various particular months on which crop grows, we need to create a season that will filter out for a particular year as winter and summer, and this should be made a realtional with other calculations for crops that we have, for example daily planted crop acres etc, how can such a model be build.

Currently we are using Azure Analysis Services with SSDT to build this kind of model, we have a date range in a separte table, how can we build the dax based on the below details:

CROP A Winter 2018 July - 2019 June

CROP B Winter 2018 July- 2019 June

CROP C Winter 2018 July- 2019 June

CROP D Winter 2018 July- 2019 June

CROP E Summer 2018 Jan - 2018 Dec

CROP F Summer 2018 Jan - 2018 Dec

CROP G Summer 2018 Jan - 2018 Dec

Above goes for each year, how the above can be achived?

[v-lili6-msft]

hi, @Anmolgan 

So sample data and expected output would help tremendously.

Please see this post regarding How to Get Your Question Answered Quickly: 
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Best Regards,
Lin