Forum Discussion

unais's avatar
unais
Icon for Helper V rankHelper V
5 years ago
Solved

Budget Values Month Wise

 

 

Referring to https://community.powerbi.com/t5/Desktop/Budget-Value-Quarter-to-Month/m-p/1392505#M592024

After Adding 2020 and 2021 Budget Value  Every Month Repeated Two Times 

 
 

 

 

 

 

 

Need Help
  • unais's avatar
    unais
    5 years ago

    below worked for me...

    Table = SELECTCOLUMNS(
    FILTER(
    CROSSJOIN(
    GLBudgetQ,
    ADDCOLUMNS(
    FILTER(
    CALENDAR(Min(GLBudgetQ[BDate]), EDATE(MAX(GLBudgetQ[BDate]),2)),
    [Date] = EOMONTH([Date],-1) + 1
    ),
    "Q", FORMAT([Date],"yyyy \Qq")
    ) ),
    FORMAT([BDate],"yyyy \Qq")= [Q]
    ),
    "GLGroup", GLBudgetQ[GLGroup],
    "Profitcenter", GLBudgetQ[Profitcenter],
    "BDate", FORMAT([Date],"Mmm YYYY"),
    "Amount", DIVIDE( GLBudgetQ[Amount] , 3 )
    )

4 Replies

  • unais's avatar
    unais
    Icon for Helper V rankHelper V
    5 years ago

    below worked for me...

    Table = SELECTCOLUMNS(
    FILTER(
    CROSSJOIN(
    GLBudgetQ,
    ADDCOLUMNS(
    FILTER(
    CALENDAR(Min(GLBudgetQ[BDate]), EDATE(MAX(GLBudgetQ[BDate]),2)),
    [Date] = EOMONTH([Date],-1) + 1
    ),
    "Q", FORMAT([Date],"yyyy \Qq")
    ) ),
    FORMAT([BDate],"yyyy \Qq")= [Q]
    ),
    "GLGroup", GLBudgetQ[GLGroup],
    "Profitcenter", GLBudgetQ[Profitcenter],
    "BDate", FORMAT([Date],"Mmm YYYY"),
    "Amount", DIVIDE( GLBudgetQ[Amount] , 3 )
    )