Forum Discussion

FrankMcQ's avatar
FrankMcQ
Frequent Visitor
6 years ago
Solved

Problems with Calendar to get a timeline column chart

Hi I have three sources of information describing a job start & end dates, when jobs were quoted and when jobs were invoiced. They are all linked by a Job ID. I'm trying to create a timeline chart ...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    6 years ago

    Hi . FrankMcQ 

    If  Table "Quotes" and Table "Calendar " relationship is inactive.

    Take a try to create a measure  by using  function of "userelationship  "  and put the measure into the visual to replace the field of "quote value" .

     

    Measure = CALCULATE(SUM(Quotes[Quote Value]),USERELATIONSHIP(Quotes[Quote Date],'Calendar'[Date]))

     

    Best Regards,
    Community Support Team _ Eason
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi . FrankMcQ 

If  Table "Quotes" and Table "Calendar " relationship is inactive.

Take a try to create a measure  by using  function of "userelationship  "  and put the measure into the visual to replace the field of "quote value" .

 

Measure = CALCULATE(SUM(Quotes[Quote Value]),USERELATIONSHIP(Quotes[Quote Date],'Calendar'[Date]))

 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.