convert date gregorian to SOLAR hijri (Live Connection to SSAS)

[Yazdanifard]

HI,

I use Power BI SQL server reporting server edition, and my data source is Analysis Services.

The problem is that I have a column that is based on Gregorian (Default type of date in SQL Server) and I want to have a column that includes Hijri date. 

How can I solve this problem?

Can I build a calculated column in SSDT?

Thanks in advance

Mostafa

[Greg_Deckler]

https://raresql.com/tag/sql-server-how-to-convert-gregorian-dates-to-hijri-date-with-formatting/

[Yazdanifard]

HI @Greg_Deckler

Thanks for your reply.

In fact, I am not allowed to edit Database.

I want to create a calculated column instead in SSAS. Do you understand what I mean?

Thanks

[Greg_Deckler]

So, are you using Power BI Desktop at all or is this entirely SQL Server?

[Yazdanifard]

Power bi (SQL server reporting services) connected to live connection (SSAS)
I need to build a calculated column I think. Don't I?

[v-yuezhe-msft]

Hi @Yazdanifard,

When you connect live to SSAS in Power BI SQL Server reporting server edition, it doesn’t allow you to create calculated column. You would need to convert gregorian date to hijri date firstly in  the data source(SSAS database), then connect to the SSAS database in Power BI SQL Server reporting server edition.

Thanks,
Lydia Zhang

[Yazdanifard]

Hi @v-yuezhe-msft

Thanks for your help.

I knew that and my question is that how to convert them to Solar hirji in SSAS. 

Regards

Mostafa

[v-yuezhe-msft]

---

@Yazdanifard wrote:

Hi @v-yuezhe-msft

Thanks for your help.

I knew that and my question is that how to convert them to Solar hirji in SSAS. 

Regards

Mostafa

---

Hi @Yazdanifard,

About the above issue, please post the question in SSAS forum to get dedicated support.

Regards,
Lydia Zhang

[Yazdanifard]

Thanks a Lot! @v-yuezhe-msft