Forum Discussion

didi42's avatar
didi42
Frequent Visitor
4 years ago
Solved

Problem to allign 'Time intelligence' measures with text fields

Hello,   I am struggling with a problem, which seems very basic but for which I cannot find any solution and would really appreciate your help.   I have a simple data set of sales of product per...
Need Help
  • didi42's avatar
    didi42
    4 years ago

    Hello,

     

    Thanks for taking the time to answer me. I tried to modify the measures with the one you provided me, however, I'm still facing the same issue.

     

    My basic understanding would be that, since with my measures "call" values from past month, then the text fields of previous month are also displayed.

    EDIT :I found a small trick which seems to work : Make a measure from my text.

     

     

    Text_as_measure = Calculate(MAX(Sheet1[Product 1 comment]))

     

     

     

    This way ,measures are shown correctly in one row and then everything is alligned

     

    Is it a correct way to do it, or could I improve it ?

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi, 

You can try this 

1. Create a measure for the total of Product 1,   Total_Product_1 = SUM(your_table[Product 1])
2. Create 2nd measure for the previous month Product 1, Previous_month_Total_Product_1= 

    Calculate([Total_Product_1],DATEADD('CALENDAR'[Date],-1,MONTH))
3. Create Variation Measure  Variation = [Previous_month_Total_Product_1]-[Total_Product_1]
 
4. Use calander slicer for changing month
didi42's avatar
didi42
Frequent Visitor
4 years ago

Hello,

 

Thanks for taking the time to answer me. I tried to modify the measures with the one you provided me, however, I'm still facing the same issue.

 

My basic understanding would be that, since with my measures "call" values from past month, then the text fields of previous month are also displayed.

EDIT :I found a small trick which seems to work : Make a measure from my text.

 

 

Text_as_measure = Calculate(MAX(Sheet1[Product 1 comment]))

 

 

 

This way ,measures are shown correctly in one row and then everything is alligned

 

Is it a correct way to do it, or could I improve it ?