Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Measure calculation with Matrix (Dates)

I´m having troubles using measures in matriz, and i hope that someone can help me. So my problem is the next: I want to calculate the sum of all where the date = date of piece, being that the date ...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous ,  Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

 

Are you trying to get same month data everywhere

The try

Full month = CALCULATE(SUM(Table[Profit]),DATESMTD(ENDOFMONTH('Date'[Date])))

 

month till date

MTD = CALCULATE(SUM(Table[Profit]),DATESMTD('Date'[Date]))

 

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    amitchandak ,For exemple:

    I have created an column "DateFull" that gets where de piece current is situated:

    And my matrix: 

    And my Measure:

    As we can see, the result in January is getting 1, but the result expected is 5 because all 5 is situated in January.