Forum Discussion

Anonymous

Not applicable

3 years ago

Solved

DAX working with two dates

I was working on a dax problem. I have the resource allocation from start date to end date.... I need to consider the average meaning divide by 12, However when we have start date or end date in be...

Need Help

amitchandak
3 years ago
Anonymous , refer if these approaches can help

Measure way
Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzM

Tables way
https://amitchandak.mediumcom/dax-get-all-dates-between-the-start-and-end-date-8f3dac4ff90b
https://amitchandak.medium.com/power-query-get-all-dates-between-the-start-and-end-date-9ad6a84cf5f2

Anonymous

Not applicable

3 years ago

FreemanZ
yes I am expecting a measure.. ill be using a matrix with all attributes as rows, year as column and measure as values

amitchandak

Super User

3 years ago

Anonymous , refer if these approaches can help

Measure way
Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzM

Tables way
https://amitchandak.mediumcom/dax-get-all-dates-between-the-start-and-end-date-8f3dac4ff90b
https://amitchandak.medium.com/power-query-get-all-dates-between-the-start-and-end-date-9ad6a84cf5f2

Forum Discussion

DAX working with two dates

Related content

Calendar Date not working with created date and resolved date

Date Slicer Not Working

Date Slicer not working properly

Date Relationship Not Working

Relative Date Filter suddenly stopped working