How to Use a Calendar Date Range to count for Different Dates in a Table

[Jarek1]

Hello everybody,

I am quite new to PBI.

the thing that I am struggling with in this moment is as follow.

there is a price of product valid from Jan 1st to March 31st

another updated price will be from April 1st.

how to make PBI show sumproduct from proper date period with corresponding product price?

I can build a calendar but I don't know how to put everything together to the time ranges.

thank you in advance.

[v-yulgu-msft]

Hi @Jarek1,

Please refer to this blog to provide more necessary details of your scenario.

Regards,

Yuliana Gu