Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Daily Rate Over Time Calculation and Visual

Hi All,    I trust You are doing well.    Situation: I would like to be able to see Daily Rates of people over time (Months) to indentify if the rates are increasing or decreasing with time.  I...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi SM, 

thanks for your suggestion, unfortunately, this is not fixing the issue that I'm having. 

The Column data types are set correctly. 

 

I need a dedicated Calendar Table as the real report is using a lot of different Fact Tables that have a Date column. 

Scenario described above is only using one facts table as an example.

I believe that my issue is that the calculation is only using one active relationship and giving me Daily rate information only at the start of the assignment but I need this information for the whole duration of the assigment. 

 

BR,

Kris

v-janeyg-msft's avatar
v-janeyg-msft
Community Support
4 years ago

Hi, Anonymous 

 

Your needs are not clear, do you only need to set Arne, what about others?

Like:

Also, can you talk about the logic and usage scenarios(use in what visual) of the Daily Rate over time (Months) of the while unit?

If you can show the desired result in visual and calculate logic, we can help you soon.

By the way, it's not easy to show rows that don't exist in the data, and connect two tables with relationships.

 

Janey