Calculate sum of a column partly basis daily sum and partly monthly sum

Anything related to PowerPivot and DAX Formuale
sunilkumar_duggirala
Posts: 1
Joined: Fri Apr 09, 2021 6:13 am

Calculate sum of a column partly basis daily sum and partly monthly sum

Postby sunilkumar_duggirala » Fri Apr 09, 2021 6:16 am

Hi,

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,
Sunil.

Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: Bing [Bot] and 6 guests

cron