Forum Discussion
Need Help with time intelligence
Hi ITManuel ,
Could you please mark your post as Answered since your problem has been resolved? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.
Best Regards
This would be the desired result.
I'm trying the follwing code which, according to my understanding should reflect the concept of DATEADD , but its not working at all.
InvCashOUTEUR =
VAR _NTP = [SelectedNTP] -- Start date project
VAR _CashOUT = [PurmICashOUTEUR] + [Mod770ValueEUR] + [PInvCashOUTEUR]
VAR _T1 =
TREATAS (
SELECTCOLUMNS (
CALCULATETABLE(
DISTINCT ( 'Date'[Date] )
),
"Date", IF ( 'Date'[Date] < _NTP, _NTP, 'Date'[Date] )
),
'Date'[Date]
)
VAR _Result =
CALCULATE (
_CashOUT,
_T1
)
RETURN
_ResultHi ITManuel ，
It's a little difficult to find the cause of problem base on current information. Could you please provide some sample data involved in your visual (exclude sensitive data) with Text format and your expected result with backend logic and special examples? By the way, Is there any relationship created between the Date table and your actual table? It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards
Hi Anonymous ,
sorry for my late answer.
To be honest I really struggle to create a sample file with non sensitive data to share. In the meantime I have solved the issue with the addition of calculated columns and additional relationships as pointed out above.
Thanks anyway
Best regards
Hi ITManuel ,
Could you please mark your post as Answered since your problem has been resolved? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.
Best Regards