Forum Discussion
PietroFarias
Resolver II
Resolver IITwo Date in Measure
I've a table with a columns date and other the price. I need create two measure, one measure return the SUM from slicer selected with column date and the other measure the SUM from other slicer with ...
I'm learning DAX. What I did was create two table with same Date: Date_1 and Date_2. After i created a relationship from DATE_1 to main table, and from DATE_2 to main table. Disable the relationships and i used USERELATIONSHIP.
Measures created:Value 1: CALCULATE([measure], USERELATIONSHIP(DATE_1[DATE], GOODS[UPDATE]) ) Value 2: CALCULATE([measure], USERELATIONSHIP(DATE_2[DATE], GOODS[UPDATE]) )
