Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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 )
)
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 )
)
below Screenshot..
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |