Forum Discussion

fjjohann's avatar
fjjohann
Frequent Visitor
9 years ago
Solved

Caluculation Quote Between Dates and Consider Product

Hello,   My Table contain 3 columns [Date] [Ativo] [Value]   There are no [Value] per [Ativo] for all [Date]   I need one Mesure:   Show the [Value] according to the [Date] selected in the D...
Need Help
  • TomMartens's avatar
    TomMartens
    9 years ago

    Perfect,

     

    guess this measure will provide what you are looking for

    lastvalue = 
CALCULATE(
	LASTNONBLANK(Cotacao[Cot], sum(Cotacao[Cot])
	) 
)

    a slight variation will provide the last date

    lastdate = 
CALCULATE(
	LASTNONBLANK('Cotacao'[Data], sum(Cotacao[Cot])
	) 
)

    Hope this helps

TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
9 years ago

And another question, does your model just contain that one table you mentioned or do you also use a separate date table?

fjjohann's avatar
fjjohann
Frequent Visitor
9 years ago

This is the Table with Values

 

 

And i Have a Calendar Table.

 

The measure must calculate the last [Cot] of each [Ativo] according to the Date selected in the Dashboard.

If it's a Month or Year or All, you should look for the last [Cot].

If there is no [Cot] for the Data and [Asset] selected, you should search for the last one.

 

  • TomMartens's avatar
    TomMartens
    Icon for Super User rankSuper User
    9 years ago

    Hey,

     

    thanks for the sharing a screenshot, maybe you will find some time to provide sample data that can be easily recreated by the people here in the community (downloadable (pbix, xlsx or csv), this will safe me a lot of time during the weekend and prevents issues with insufficient sample data.

     

    Thanks

      • TomMartens's avatar
        TomMartens
        Icon for Super User rankSuper User
        9 years ago

        Perfect,

         

        guess this measure will provide what you are looking for

        lastvalue = 
CALCULATE(
	LASTNONBLANK(Cotacao[Cot], sum(Cotacao[Cot])
	) 
)

        a slight variation will provide the last date

        lastdate = 
CALCULATE(
	LASTNONBLANK('Cotacao'[Data], sum(Cotacao[Cot])
	) 
)

        Hope this helps