Getting date values in measure for each row

[Anonymous]

Hello Everyone!!
Can anyone please tell me how to get date value for each row of table in a measure with some filters?

Thanks

[amitchandak]

@Anonymous , Each row in case measure measure you have display as each row or force calculation from each low

like

Sumx(Values(Table[ID]),[Measure])

This forcing to calculation to happen from ID level

Between two tables

https://community.powerbi.com/t5/Community-Blog/Decoding-Direct-Query-in-Power-BI-Part-2-Date-Difference-Across/ba-p/934397#M451

[Anonymous]

@amitchandak my scenerio is a little bit different. I am selecting a date from slicer which is the end date of each month and i want to subtract that date to each row of its connected accumlative fact table date coloumn.
How can I achive this? 
thanks for your help and for your reply

[v-yingjl]

Hi @Anonymous ,

Looks like you want to get the day diff between the slicer date and fact date, you can create a measure like this:

Result date =
DATEDIFF (
    SELECTEDVALUE ( 'Fact date'[date] ),
    SELECTEDVALUE ( 'Date'[date] ),
    DAY
)

Attached a sample file in the below, hopes to help you.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.