Forum Discussion

Lukester's avatar
Lukester
Frequent Visitor
10 years ago
Solved

Fiscal Quarter text to date help

Need help!!!! I am working with excel workbook that I have imported into PowerBI and in the table, there is a column called Fiscal Quarter. The values are formatted as text like "2015 Q1", "2014 Q4"....
Need Help
  • v-haibl-msft's avatar
    v-haibl-msft
    10 years ago

    Lukester

     

    If you have different Fiscal Quarters, you can just replace the actual start and end dates in provided formulas.
    Just to confirm, do you have any other questions have not been solved?

     

    Best Regards,
    Herbert

  • Vvelarde's avatar
    Vvelarde
    10 years ago

    Lukester

     

    Just replace

     

    "Q4" ,"1/1/" & FiscalYear

     

    by

     

    "Q4" ,"1/1/" & (FiscalYear)+1

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
10 years ago

Lukester

 

If you have different Fiscal Quarters, you can just replace the actual start and end dates in provided formulas.
Just to confirm, do you have any other questions have not been solved?

 

Best Regards,
Herbert

fansari16's avatar
fansari16
Frequent Visitor
7 years ago

Hi Luke,

 

Can you look my post. I have some problems too.