Forum Discussion

arulsettu's avatar
arulsettu
Frequent Visitor
9 years ago

Fixed in power bi

HI,      I am very new to power bi. acutally i am trying to convert TABLEAU app into power bi.   in a chart there is caluclated dimension created as below   { FIXED [Year Week]: MAX([End Time])...
Need Help
arulsettu's avatar
arulsettu
Frequent Visitor
9 years ago

Thanks for the reply

 

by using this

 

CALCULATE(MAX([end_time].[Date]),ALLEXCEPT('table_name',[Year]))

 

i am getting only one value 

 

31/dec/2016

 

 

and above calcluation i am using as dimension.

 

can you check this

 

 

Thanks

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi arulsettu,

 

>>i am getting only one value 

If you only drag this measure to a visual, you will get the max date. You can add other columns to work through this issue.

 

Regards,

Xiaoxin Sheng

  • arulsettu's avatar
    arulsettu
    Frequent Visitor
    9 years ago

    i am using this as dimension

     

    CALCULATE(MAX([end_time].[Date]),ALLEXCEPT('table_name',[Year]))

     

    and 

     

    count(value)

     

    so where and what should i add as anew column

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi arulsettu,

       

      You should add a index column to let the measure calculate loop the table.

       

      For example:

       

       

      Notice: Count(value) will summarize this field

       

      Regards,

      Xiaoxin sheng

      • arulsettu's avatar
        arulsettu
        Frequent Visitor
        9 years ago

        i am doinglike below is this correct

         

        Thanks