Forum Discussion
New table using variable and custom columns
- 6 years ago
Hi Anonymous ,
Sorry for that, but we cannot reproduce this issue on my side with your shared DAX code,
We created a sample “t_intervention” table, and then create two calculated tables with your code, we got the result as following,
We can also use ADDCOLUMNS function to add a column to tables, such as following:
a_calendrier_global = VAR _mon_calendrier_ = CALENDAR ( FIRSTDATE ( t_intervention[int_date_programmation].[Date] ); LASTDATE ( t_intervention[int_date_programmation].[Date] ) ) RETURN ADDCOLUMNS ( _mon_calendrier_; "test"; "Hello world !" )Could you please reproduce this issue with the latest version of Power BI Desktop ? If it does not contain any confidential information, could you please provided a screenshot which contains error information.
BTW, pbix as attached.
Best regards,
Hi Anonymous ,
Sorry for that, but we cannot reproduce this issue on my side with your shared DAX code,
We created a sample “t_intervention” table, and then create two calculated tables with your code, we got the result as following,
We can also use ADDCOLUMNS function to add a column to tables, such as following:
a_calendrier_global =
VAR _mon_calendrier_ =
CALENDAR (
FIRSTDATE ( t_intervention[int_date_programmation].[Date] );
LASTDATE ( t_intervention[int_date_programmation].[Date] )
)
RETURN
ADDCOLUMNS ( _mon_calendrier_; "test"; "Hello world !" )
Could you please reproduce this issue with the latest version of Power BI Desktop ? If it does not contain any confidential information, could you please provided a screenshot which contains error information.
BTW, pbix as attached.
Best regards,
It now works... I don't know what happened, sorry for the post...
But thanks for your time !