Forum Discussion
Bakhtawar
7 years agoPost Patron
Load inline query in power bi
I have a inline query in qliksense script now i want to load that inline query in power BI. I am new in power bi also i am done with some research but i did not find specific.. what should i do
yet i did not try any thing ,
and i have this inline query in qlik sense script .. i want to create master calendar
Let vCalStartDate = '01-Jul-2015';
Let vCalEndDate = '30-Jun-2017';
Invo_Calender:
Load
Date(Date('$(vCalStartDate)')+IterNo()-1) as %Key_Join_Date,
year(Date(Date('$(vCalStartDate)')+IterNo()-1)) as Normal_Year,
AddMonths((Date('$(vCalStartDate)')+IterNo()-1),6) as Fiscal_Date,
Month(AddMonths((Date('$(vCalStartDate)')+IterNo()-1),7)) as Fiscal_Month,
QuarterName(Date('$(vCalStartDate)')+IterNo()-1) as Fiscal_Quarter,
Year(AddMonths((Date('$(vCalStartDate)')+IterNo()-1),6)) as Fiscal_Year
AutoGenerate 1 While MonthEnd(Date('$(vCalStartDate)')+IterNo()-1) <=
MonthEnd('$(vCalEndDate)');
```
1 Reply
- v-frfei-msftCommunity Support
Hi Bakhtawar ,
Currently, we cannot load a inline query in qliksense script into power bi. To be honest, I am not an expert of qliksense. I recommend to have a try of DAX function calendar.