Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Fixed or static column in table

Hi everyone   I hope you all have a good day at the office   I have a table which consist of financial data, and I would like to have one or two fixed columns in the table. The other columns shou...
Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    4 years ago

    Hi Anonymous ,

     

    You can create dynamically changing values directly with functions like today(), now(). For example, for now(), every time you perform a refresh, the calculated column will display the current time and date.

    after refresh:

     

    Alternatively, you can create different calculated columns based on other filtering criteria, such as:

     

    Col_sum = CALCULATE(SUM(financials[Profit]),ALL(financials),financials[Year]=2013)
    Col_sum = CALCULATE(SUM(financials[Profit]),ALL(financials),financials[Year]=2014)

     


    If the problem is still not resolved, please point it out. Looking forward to your reply.


    Best Regards,
    Henry


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-henryk-mstf's avatar
v-henryk-mstf
Community Support
4 years ago

Hi Anonymous ,

 

You can create dynamically changing values directly with functions like today(), now(). For example, for now(), every time you perform a refresh, the calculated column will display the current time and date.

after refresh:

 

Alternatively, you can create different calculated columns based on other filtering criteria, such as:

 

Col_sum = CALCULATE(SUM(financials[Profit]),ALL(financials),financials[Year]=2013)
Col_sum = CALCULATE(SUM(financials[Profit]),ALL(financials),financials[Year]=2014)

 


If the problem is still not resolved, please point it out. Looking forward to your reply.


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.