PowerPivot Excel 2016 Dax/Measure - Calculation with Date

Anything related to PowerPivot and DAX Formuale
ajibios@hotmail.com
Posts: 2
Joined: Thu Sep 20, 2018 2:32 pm

PowerPivot Excel 2016 Dax/Measure - Calculation with Date

Postby ajibios@hotmail.com » Thu Sep 20, 2018 2:38 pm

3- Week-To-Date or WTD spend on grocery only from among other items (I have two linked tables, calendar table and fact table containing ITEMS, AMOUNT and Date fields)
4 – Previous Week spend on grocery only from among other items (I have two linked tables, calendar table and fact table containing ITEMS, AMOUNT and Date fields)
5- Previous Quarter spend on electronics only from among other items (I have two linked tables, calendar table and fact table containing ITEMS, AMOUNT and Date fields)
6- Previous Year spend on electronics only from amongst other items (I have two linked tables, calendar table and fact table containing ITEMS, AMOUNT and Date fields)
7- Count Contract id as the total number of valid contracts and amount spend (from fields: ‘Contract ID’ must be “CNT777”, ‘Amount’, ‘Award Date’ must be between, ‘Start date’ and ‘End Date’)

Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 8 guests

cron