Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Year on Year Difference

Hi @all, Is it possible to create a measure to find variance in PowerBI like below?  
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Ashish,
I really appreciate your solution. Unfortunately, I'm experiencing an error: "A function 'DATESBETWEEN' has been used in a True/False expression that is used as a table filter expression. This is not allowed"

CALCULATE ( [Net Debt], DATESBETWEEN ( DimValdate[ValDate], MAXX ( ALLSELECTED ( DimValdate ), DimValdate[ValDate] ), MAXX ( ALLSELECTED ( DimValdate ), DimValdate[ValDate] ) ) - CALCULATE ( [Net Debt], DATESBETWEEN ( DimValdate[ValDate], MINX ( ALLSELECTED ( DimValdate ), DimValdate[ValDate] ), MINX ( ALLSELECTED ( DimValdate ), DimValdate[ValDate] ) ) ) )
Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

You are welcome.  There should be another closing bracket before the - sign and remove one closing bracket from he end.

If it still does not work, then share the download link of the PBI file.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Ashish,
    The modified formula did work but unfortunately didn't achieve what was actually expected.
    Rows: ValDate (i.e Dec & June)
    Columns: Fiscal Year (FY23, FY24,....)
    Value: Net Debt(measure) , Net Debt Variance