Two dates conditions question

[Anonymous]

Story Added = IF('Sprint Burndown'[Date].[Date] < 'Sprint Burndown'[Sprint Start Date].[Date], ('Sprint Burndown'[Story Sprint End]),0)

How would I add logic in addition, of this? If it falls between two dates basically

Story Added1 = IF('Sprint Burndown'[Date].[Date] < 'Sprint Burndown'[Sprint Start Date].[Date] && ('Sprint Burndown'[Date].[Date] > 'Sprint Burndown'[Sprint End Date].[Date] , ('Sprint Burndown'[Story Sprint End]),0)

[Anonymous · Accepted solution]

Hi  @Anonymous ,

According to the design of Power BI Desktop, the same column data format can only be one, so it is recommended that the 0 of your function be Blank(), so that the Date will be displayed normally, if it is 0, it will all become a value, such as the following:

Here are the steps you can follow：

Measure.

Measure =
IF(
    MAX('Sprint Burndown'[Date])>MAX('Sprint Burndown'[Sprint Start Date])&&
    MAX('Sprint Burndown'[Date])<MAX('Sprint Burndown'[Story Sprint End]),
    MAX('Sprint Burndown'[Story Sprint End]),BLANK())

If you're using Measure, you'll need to click "Show itmes with no data", otherwise blank() will be omitted automatically.

Calculated column.

Column =
IF(
    'Sprint Burndown'[Date]>'Sprint Burndown'[Sprint Start Date]&&
    'Sprint Burndown'[Date]<'Sprint Burndown'[Story Sprint End],
    'Sprint Burndown'[Story Sprint End],BLANK())

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[amitchandak]

@Anonymous , Are looking something like HR Blog

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970

or

Between Dates - Dates between
Tables
https://amitchandak.medium.com/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

Measure way
Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzM
https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-or-end-date/ba-p/1503785