Forum Discussion

annam's avatar
annam
Frequent Visitor
2 years ago

Need help with Clustered Column Chart

I have this data where I need to calculate 2 calculations for previous, current and next month. Basically to track which payemnt are guaranted in current month, how much much will be guranted next mo...
Joe_Barry's avatar
Joe_Barry
Icon for Solution Sage rankSolution Sage
2 years ago

Hi annam 

Are you usinga  Date Table in your Data Model? If yes, please tyr this.

 

  • Create an Active one to many relationship from the date table to the Invoice Date
  • repeat for the Est invoice Date and Invoice accepted date, but this will automatically be in active
  • Create the first measure

 

Invoiced =
SUM(Table[Total Amount])​

 

  • Create the 2nd

 

Est. invoice =
CALCULATE([Invoiced], USERELATIONSHIP(Date[Date], Table[Est. Invoice Date]))​

 

  • Create the 3rd

 

Invoice Accepted =
CALCULATE([Invoiced], USERELATIONSHIP(Date[Date], Table[Invoiced Accepted Date])​

 

Add the date from the date table to a visual then the measures

 

Hope this helps

Joe