Forum Discussion

Grazmeister's avatar
Grazmeister
Regular Visitor
4 years ago
Solved

How to show data divided by future months

Hello everyone,  I usually use this community to find help and ideas for my Power BI dashboards but it's my first time posting, since I cannot get around a problem.  WHAT I HAVE: I have data a...
Need Help
Grazmeister's avatar
Grazmeister
Regular Visitor
4 years ago

Thanks, amitchandak !

Your solution worked!

I needed to add an Index column so it could treat each line distinctively and needed to change the comparison of the end date (Saída Data) to "<" instead of "<=". 

 

The formula which worked is this:

Value by day of Month =
CALCULATE(
SUMX(
SUMMARIZE(
FILTER(
CROSSJOIN(
'Conceitos Cobrados',
'DATAS_fitas'
),
'DATAS_fitas'[Date] >= 'Conceitos Cobrados'[Entrada Data] && 'DATAS_fitas'[Date] < 'Conceitos Cobrados'[Saída Data]
),
'Conceitos Cobrados'[Index],
'DATAS_fitas'[Date],
'DATAS_fitas'[YearMonthnumber],
'Conceitos Cobrados'[Valor],
'Conceitos Cobrados'[Entrada Data],
'Conceitos Cobrados'[Saída Data]
),
DIVIDE(
'Conceitos Cobrados'[Valor],
DATEDIFF(
'Conceitos Cobrados'[Entrada Data],
'Conceitos Cobrados'[Saída Data],
DAY
)
)
)
)
 
Thanks for your help!