Forum Discussion

cosmasadesegha's avatar
cosmasadesegha
Frequent Visitor
6 years ago
Solved

Burndown

Hey Guys,   I am trying to burdown a project fund that span through two years. I was trying this Dax function that someone shared here but it was  not working as expected.......DATESYTD('Date'[Date...
Need Help
  • sturlaws's avatar
    sturlaws
    6 years ago

    Hi cosmasadesegha 

     

    Not sure if you have solved this or not, but have you tried to change this part of your measure

    WBSFundingAmount - CALCULATE( [SumTotalTest], DATESYTD('Date'[DateKey], "31/12"))

    to

    WBSFundingAmount
    - CALCULATE (
        [SumTotalTest],
        FILTER (
            ALL ( 'Date' ),
            'Date'[year] = MAX ( 'Date'[year] )
                && 'Date'[DateKey] <= MAX ( 'Date'[DateKey] )
        )
    )

     

    Cheers,
    Sturla

    If this post helps, then please consider Accepting it as the solution. Kudos are nice too.

cosmasadesegha's avatar
cosmasadesegha
Frequent Visitor
6 years ago

Thanks Parry2k for your response. I actually have a date table and I used it for time intellegence calculcation. The issue is I need the right dax fuction to fix that problem...

sturlaws's avatar
sturlaws
Resident Rockstar
6 years ago

Hi cosmasadesegha 

 

Not sure if you have solved this or not, but have you tried to change this part of your measure

WBSFundingAmount - CALCULATE( [SumTotalTest], DATESYTD('Date'[DateKey], "31/12"))

to

WBSFundingAmount
    - CALCULATE (
        [SumTotalTest],
        FILTER (
            ALL ( 'Date' ),
            'Date'[year] = MAX ( 'Date'[year] )
                && 'Date'[DateKey] <= MAX ( 'Date'[DateKey] )
        )
    )

 

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.