Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Distribute dates between start and end date in Direct Query

Hi all,   I have a question with which I am struggling for some days already. I have a Power BI dataset which is connected to Dataverse via the Azure SQL connection. I am using Direct Query as the ...
Need Help
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    Hi Anonymous ,

     

    It is no possible to create a custom table in DirectQuery mode, but you can create a table during calculation, like summarize().

    Expression you can refer this as below:

     

    Pbix in the end you can refer.

    Best Regards

    Community Support Team _ chenwu zhu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

v-chenwuz-msft's avatar
v-chenwuz-msft
Community Support
4 years ago

Hi Anonymous ,

 

It is no possible to create a custom table in DirectQuery mode, but you can create a table during calculation, like summarize().

Expression you can refer this as below:

 

Pbix in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.