cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mehaboob557 Member
Member

Re: Help needed to get data in between 2 values with where conditon in DAX

Hi @v-chuncz-msft,

 

I tried your dax function. I am getting the below error.

 

eroor.PNG

 

Please help me how can i overcome

kundan Frequent Visitor
Frequent Visitor

Re: Help needed to get data in between 2 values with where conditon in DAX

Hi Mehaboob,

 

Here are the step I followed:

 

Step1: Take the quateNo where version=1.0 and make a new file

Step 2: Import sample.csv and new file with quateNo where version=1.0

Step 3: Make relationship between these two files 1to many

Step 4: create a table with required column and use quoteno from second file.

Step 5: put visual filter where version is less than 1.1

 

Here is link to pbxi file.

 

Regards,

Kundan

Community Support Team
Community Support Team

Re: Help needed to get data in between 2 values with where conditon in DAX

@mehaboob557,

 

I meant a calculated table.

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