Forum Discussion
cdoblare28
3 years agoFrequent Visitor
Differentials Calculation
Hello, I am currently finding trouble with the calculation of Differentials (Value of Today - Previous Value). Find here a screenshot of the table used: I have several Indexes and...
amitchandak
3 years agoSuper User
cdoblare28 , Based on what I got.
Create a date table.
Then join it with date of your table and then create a measures like
M1 = countrows(Table)
m2= Countx( Date, if(isblank([M1]), [Date], blank() )
use M2 with date from date table
cdoblare28
3 years agoFrequent Visitor
amitchandak appreciate your response, but I think that does not solve the problem. The output of that table is a lines chart, so if I generate artificially dates, that chart is not going to be good because it will consider dates without quotations flat respect the latest value. I think that what I need is just a measure.