Forum Discussion

Bakhtawar's avatar
Bakhtawar
Post Patron
7 years ago

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