DAX problem

[Anonymous]

Hello

I have been tasked with creating a performance against targets dashboard that has previously been manually created in a spreadsheet.

There are various measures that use a count of dates and DAX time calculations, and it has a slicer that selects the current month.

The original report has a “targets” column that is a subtraction of the “comps received current month” column which is a DAX measure.

Comps Recieved Current Month =

CALCULATE (

    'Performance Against Target'[Count of 1628],

    USERELATIONSHIP ('Performance Against Target'[1628], DimDate[Date] )

)

The targets where previously just entered onto a spreadsheet and change every month.  They are not input on the database anywhere.

I created a linked spreadsheet which I put in the targets against each referrer.

I was unable to create a measure or column that would subtract the two, the intellisence in the formula bar would not even recognise the imported spreadsheet with the targets.

I have done a lot of googling and have been unable to solve this problem.

Does anyone have any idea about how I might achieve this?

Many thanks

Charlie

[Anonymous]

Yes the ir exacty the problem.

The targets where previously just entered onto a spreadsheet and change every month.  They are not input on the database anywhere.

[Icey]

Hi @Anonymous ,

I can't speculate the issue. Could you create a dummy .pbix file with the same issue for us to test? Please don't contain real data and sensitive information.

Best Regards,

Icey

[Anonymous]

Hi

The targets where previously just entered onto a spreadsheet and change every month.  They are not input on the database anywhere.

Thanks

[amitchandak]

@Anonymous , if they have been imported , they (target and actual) can analzyed togther with common dimensions .

sum(Target[Target])

sum(Sales[Sales])

[parry2k]

@Anonymous Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[littlemojopuppy]

@Anonymous is the issue that the data isn't imported into your data model?  Or with the DAX formula?