Show amount for over a period of time but without dates :(

[Anonymous]

Hello everyone,

Does anybody here created a report that shows the amount for over a period of time but the data itself doesn't have dates?

I have a date dimension but I don't know how to combine it with my data.

This is my sample data:

Country	Total Amount
Country A	100

For Month of October:

Country	Month	Amount
Country A	January	10.00
Country A	February	10.00
Country A	March	10.00
Country A	April	10.00
Country A	May	10.00
Country A	June	10.00
Country A	July	10.00
Country A	August	10.00
Country A	September	10.00
Country A	October	10.00

Month of November:

Country	Month	Amount
Country A	January	9.09
Country A	February	9.09
Country A	March	9.09
Country A	April	9.09
Country A	May	9.09
Country A	June	9.09
Country A	July	9.09
Country A	August	9.09
Country A	September	9.09
Country A	October	9.09
Country A	November	9.09

[dax · Accepted solution]

Hi ogureisuo,

You could try below to see whether it work or not. Create relationship and measure like below

Measure 2 = SUM('Table 2'[AMOUNT])/CALCULATE(COUNT(t2[MONTH]),ALL(t2))

Best Regards,
Zoe Zhi

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

[Anonymous]

Thank you so much!!