Forum Discussion

szaman's avatar
szaman
New Member
8 years ago
Solved

Dynamic Column Calculation Based on Date Slider

Hi, I am fairly new to Power BI and would greatly appreciate it if someone can help me with this business case.   Problem statement seems simple.  I need to calculate total employee cost at any giv...
Need Help
Tips and Tricks
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    Edit your m_totalCost formula to

     

    = if(HASONEVALUE('FTE Tracking'[Masked Employee]),[m_Variance Against Actual]* max('FTE Tracking'[c_Run Rate EUR])/30,SUMX(SUMMARIZE(VALUES('FTE Tracking'[Masked Employee]),[Masked Employee],"ABCD",[m_Variance Against Actual]* max('FTE Tracking'[c_Run Rate EUR])/30),[ABCD]))

     

    Hope this helps.

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

Share the link from where i can download your file.

szaman's avatar
szaman
New Member
8 years ago

Hi, here's the link the files. Thank you in advance.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    Hi,

     

    Edit your m_totalCost formula to

     

    = if(HASONEVALUE('FTE Tracking'[Masked Employee]),[m_Variance Against Actual]* max('FTE Tracking'[c_Run Rate EUR])/30,SUMX(SUMMARIZE(VALUES('FTE Tracking'[Masked Employee]),[Masked Employee],"ABCD",[m_Variance Against Actual]* max('FTE Tracking'[c_Run Rate EUR])/30),[ABCD]))

     

    Hope this helps.

     

    • szaman's avatar
      szaman
      New Member
      8 years ago

      This works like a charm!!!! I would not have been able to figure this out myself. Thank you very much.

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        8 years ago

        You are welcome.