Forum Discussion
fsadiq
2 years agoFrequent Visitor
Split a value across 12 months/A year
Hi All, I have a table from a SharePoint List as shown below What i want is to split the Priority_Amount into 12 Months/1 Year as shown below by leveraging the year of any of the Urgent_da...
Syndicate_Admin
Administrator
2 years agoThat seems straightforward. You have a calendar table, right? What have you tried and where are you stuck?
fsadiq
2 years agoFrequent Visitor
Hi , I was able to create a date table to capture and divide the value by 12 Months.
The issue now is that it does not filter when i make selection simply because there is no connection between the Date Table and Main Table.
i took below steps:
1. I created a date Table and added a column with the below
Priority Amount =
var _start=DATE(2024,1,1)
var _value=[Priority]
var _end=EOMONTH(_start,11)
return IF('Date'[Date]>=_start&&'Date'[Date]<_end && DAY('Date'[Date])=1,_value/12)Where priority is a calculated DAX measure from the below table.
Priority = sum(Unit_UrgentNeed[Priority_Amount])I was able to get the below:
If i add a slicer, and include Title column, If i select any of the title values, it does not filter the new date table.I guess a relationship needs to be created within this 2 Tables.
Thanks in Anticipation.