cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
regasanyoto Member
Member

Calculate the SUM in a quarter period from one table

Hello all,

 

I have one table which i am using to sum the buyed licenses per each SnapShotDate_.

 

In the SnapshotDate_ there must be only  4 dates which are: 2/2/2018, 2/3/2018, 2/4/2018 and 2/5/2018 to make the calculation of the SUM of BuyedLicense.

 

The expected result of the solution must be:

 

Picture 1: 

2018-05-08 14_47_47-user license.csv - Excel.png

 

 

But in my table i have in the column Snapshotdate_ differents 2/2/2018, 2/3/2018, 2/4/2018 and 2/5/2018. This result in an wrong calculation.

 

Picture 2:

 

W2018-05-08 14_39_42-User License - Power BI Desktop.png

 

 

Any suggestions to get the result of the first picture ?

 

Many thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

Re: Calculate the SUM in a quarter period from one table

Hi @regasanyoto


This behavior occurs because there is no relationship between tables Fact Order user license and Fact user license new. To solve it, set Cross filter direction as both for the relationships you have with the dim date table.

 

Regards.

2 REPLIES 2
regasanyoto Member
Member

Re: Calculate the SUM in a quarter period from one table

This is my current model right now:

 

 

2018-05-09 00_07_35-User License - Power BI Desktop.png

Anonymous
Not applicable

Re: Calculate the SUM in a quarter period from one table

Hi @regasanyoto


This behavior occurs because there is no relationship between tables Fact Order user license and Fact user license new. To solve it, set Cross filter direction as both for the relationships you have with the dim date table.

 

Regards.