Forum Discussion

Copper Contributor

Jul 24, 2023

Data model from Power BI to Excel

Hi everybody, I'd like to import a Data Model made in pbix into an xlsx, so passing from Power BI to Excel. I unzipped both, copied the DataModel file from the pbix, renamed it as item.data and...

Copper Contributor

Jul 30, 2023

SergeiBaklan I understand. I raised this ticket because I need to implement in my project just a simple feature which would consist in the possibility to have a filter, in a power pivot, that consider some time intelligence labels such as YTD, MTD, WTD and so on.

In order to achive this I created in my Excel file two tables: Time Intelligence Selection (with all the labels per date) and the Calendar. The point is that there's a one to many relationship and not a many to one that I would need.

Do you think there's a way to achieve the result considering that importing a data model in Excel is no longer feasible?

Thanks,

Natan

SergeiBaklan

Diamond Contributor

Jul 30, 2023

NateP86
So, that's cross filtering in both direction on model like

filter could be like

For such model you could do everything in Excel. Major part of the job could be done with CROSSFILTER(), e.g. for above sample like

Measure, new = CALCULATE(
	[Measure, old],
	CROSSFILTER(Period[Datekey],Calendar[DateKey],Both)
)

Assume you don't use implicit measures, but that's best practice in any case.