Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Periodic billing

Hello -   I'm trying to utilize Phil Seamark's periodic billing measure but am having trouble. Here is that link: https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/4093...
Need Help
Show and Tell
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Draw Schedule =
VAR tmpCalendar = ADDCOLUMNS('Disconnected Date',"Month",MONTH([Date]),"Year",YEAR([Date]),"MonthYear",VALUE(YEAR([Date]) & FORMAT(MONTH([Date]),"0#")))
VAR tmpBilling = ADDCOLUMNS('POWER BI - Gantt w NOR 191030',"MonthYearBegin",VALUE(YEAR([Est Start Date]) & FORMAT(MONTH([Est Start Date]),"0#")),
"MonthYearEnd",VALUE(YEAR([Est Comp Date]) & FORMAT(MONTH([Est Comp Date]),"0#")))
VAR tmpTable =
SELECTCOLUMNS(
FILTER(
GENERATE(
tmpBilling,
SUMMARIZE(tmpCalendar,[Year],[Month],[MonthYear])
),
[MonthYear] >= [MonthYearBegin] &&
[MonthYear] <= [MonthYearEnd]
),
"Customer",[Project ID & Description],
"Amount",[NOR]
)
RETURN SUMX(tmpTable,[Amount])

  • v-xuding-msft's avatar
    v-xuding-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ,

    Did you solve the problem? Did you check the data type of the columns? If my answer is helpful, please accept it as a solution. If you are still confused about it, please share your dummy file. Then I will understand clearly and solve it as soon as possible.

     

    Best Regards,

    Xue Ding

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Kudos are nice too.