Add days to a date and use it as column in Matix

[Talal141218]

Hi There, 

i had crate a measure as you see in below and want to use this as column in Matrix but don't work. 

= NEXTDAY(Dim_DateEstimatedDelivery[DateEstimatedDelivery_NK])+9

hat anyone en Idee why that happend ? 

Thanks alot. 

[tamerj1 · Accepted solution]

Hi @Talal141218 
Following to our discussion, you can use

=
IF (
    NOT ISEMPTY ( Dim_DateEstimatedDelivery ),
    SELECTEDVALUE ( Dim_DateEstimatedDelivery[DateEstimatedDelivery_NK] ) + 10
)

[Talal141218]

Hi @tamerj1 , 

 if i understand your quation my Data model is SQL Server Analysis Services and (ETD) column belong to Estimate time of dispatsh Table in another hand (container ID) column belongs to Procurements  Table. 

farthermore i don't know what is the relationships between the Tables, because there is IT Company create the Data Model. I have authority just to make measures and reports. nothings to do with Data. 

i hope, that's i got ur Point and answered ur quations. 

Thanks in Advance. 

[tamerj1]

Hi @Talal141218 
It looks to me that most probably both tables are fact tables. There must be some Dim table(s) connecting the two tables. If we don't have the full picture we won't be able to do anything. Maybe you cannot change (add/remove/alter) relationships but for sure you can view them either through SSAS itself or from power bi model view icon 

[Talal141218]

i want to correct my statement , all belongs to one Table( Purchorderline). Data relashenship very complix i take Pic if that's enough. 

[tamerj1]

@Talal141218 
I thinkwe need to connect perhaps via teams or zoon later on today. Let me know if you can do that.

[Talal141218]

@tamerj1 i understand now, what do you means Etimate time of Dispatsh belong to Dim-Table and Container ID belongs to Fact- Table, and there is relationship between two tables . I apprciate your help, we can today via Teams if you wish. 

[tamerj1]

@Talal141218 
I have some time now if you wish to connect?

[Talal141218]

me too, how can i connect you ? 

[tamerj1]

@Talal141218 
I will share a meeting link with you in a private message

[Talal141218]

@tamerj1 

if you send me ur email in private i will send you invitaion by email. i prefer not in puplic yestarday was in this site hackers attack. 

thanks for ur understanding 

[Talal141218]

Hi Thanks for replay

i think you right, but i am neu Power BI user can you help me to crate a measure please.

look at the pictures below please: 

you will see, wenn i add the Container ID from another Tabell, the Measure dosn't work. 

thanks in advance 

[Anonymous]

Hi @Talal141218 ,

//i had crate a measure as you see in below and want to use this as column in Matrix

The matrix does not accept measure as its column value fields. 

Please consider creating a calculated column. Can you explain what you expect the result to be?

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[Talal141218]

Thanks a lot for ur replay, 

i want to add a column to increase the date 10 Tage. 

and i faced problems as below: 

than after i add the Container ID so : 

thanks in advance 

[tamerj1]

Hi @Talal141218 
I suspect that the value of th measure is not filtered when placed inside the visual. If this is the case then you need to add some CALCULATE - CROSSFILTER - BOTH agument in order to transfer the filter from one dim. to another.

[Talal141218]

Hi, 

how can i do that ? sorry  i am neu user in Power BI. 

Thanks alot. 

[tamerj1]

Hi @Talal141218 

please share more details about your data model and relationships. Also indicate which columns and in which tables are we talking about.