How to change datasource settings in pbix file from on premise server to snowflake

[Naseema]

Hi,

I want to change data source settings in pbix file in powerbi desktop from onpremise server to snowflake .

I have same tables in snowflake, i want to change the source.

Help me for this scenario.

[Samarth_18]

Hi @Naseema ,

You could create a measure as below:-

_measure =
SUMX (
    FILTER (
        ALL ( 'Table'[Date] ),
        'Table'[Date] <= MAX ( 'Table'[Date] )
    ),
    [number of position filled]
)

[alekhved]

hi @Naseema 

Not sure if I am missing something. But if we just have to create a DAX measure to calculate difference between two columns, it looks like

Diff =

SUM('Table'[Value1]) - SUM('Table'[Value2])

Thanks!

alekh

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

[Naseema]

@alekhved Thanks for u r response,

I did update the my post with detailed info.

[alekhved]

hi @Naseema ,

Could you be please more clear with the expectation. The attached screenshot doesn't imply what is needed or how the number would be derieved.

Thanks!