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.
1. I have deploy model with calculated table
=ADDCOLUMNS(
CALENDAR ( DATE (2021,1,1), DATE (2021,12,31) ),
"Miesiąc Rok",FORMAT ( [Date], "mmm yyyy" ),
"Rok Miesiąc", FORMAT ( [Date],"yyyy mmm" ),
"Rok Miesiąc Numer", FORMAT ( [Date], "yyyy-mm" ),
"Miesiąc Rok SORT", YEAR([Date]) * 100 + MONTH([Date]),
"Kwartał","Q" & QUARTER ( [Date] ),
"Kwartał Numer", QUARTER ( [Date] ),
"Kwartał Rok","Q" & QUARTER ( [Date] ) & FORMAT ( [Date], " yyyy" ),
"Rok Kwartał",FORMAT ( [Date], "yyyy " ) & " Q" & QUARTER([Date]),
"Kwartał Rok SORT",YEAR([Date]) * 100 + QUARTER([Date]),
"CzyAktualnyMiesiac",IF(YEAR([Date]) = YEAR(NOW()) && MONTH([Date]) = MONTH(NOW()),1,0),
"Rok",YEAR([Date]),
"Miesiąc",MONTH([Date])
)
2. Second source is db2 database
After deploy i have error when i add calculated table to Power BI
"DataSource.Error: AnalysisServices: The query referenced calculated table 'Data' which does not hold any data because there is an error in its expression.
Details:
DataSourceKind=AnalysisServices
DataSourcePath=w6q7-tst2;TabularProject2test"
Sources Db2 working ok.
Everything working OK in Excel Power Query.
Solved! Go to Solution.
Resolved: The QURTER function is not allowed even though it is not an error in Visual Studio.
Resolved: The QURTER function is not allowed even though it is not an error in Visual Studio.
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 |
---|---|
15 | |
7 | |
5 | |
3 | |
3 |