I am trying to create power pivot table to get Sum of Cash Flow receivables in values and I have created pivot table with Dates in columns and product names in rows. In the data model table, i have product names, date values and amount details available.
I need to create pivot table as Dates in columns to be displayed as date + 10 working days on daily basis and after that end of month dates to be displayed for remaining dates.
I am able to create pivot table with Dates displayed up to 10 days continuously and after that end of the month dates for remaining dates.
Now, i got struck at measure formula, as i want the PowerPivot to ignore date values in column after 10 days and compute sum of cashflows on monthly basis with end the month date available in column. I tried multiple ways but could not succeed. Could you please help with the method or formula to get Sum of Cash flow on daily basis for first 10 days and after that end of the month basis.
Thank you very much,
Anything related to PowerPivot and DAX Formuale
1 post • Page 1 of 1
Who is online
Users browsing this forum: No registered users and 5 guests