Forum Discussion

Anonymous

Not applicable

7 years ago

If Condition

Hello All, Iwas using IF condition to calculate based on condition. While applying formula i could not able to select the comlumn name to filter the data. fpr example I've a table with column...

Anonymous

Not applicable

7 years ago

Hello Ashish,

I dint get any value.

REgards

Super User

7 years ago

Hi,

Share the link from where i can download your PBI file.

Anonymous
Not applicable
7 years ago
Hello Ashish,

I could able to share sample data which is similar to my data.

I've data from fy14 till date and month is recorded as first day of the month pattern.
've client with size, if you abservve the client 3 whihc is a bundled type implies has say 500 clients (from columnH), my req is if i need the count for each month Client1,client2, client4 should display as 1 but for client3 it should count as 500 for month of April and 505 in May any dynamically change monthly.

Please let me know if you need further details.

https://drive.google.com/file/d/1BAfwWWw-_caH8VQXl_l3h1nckvfQ_WjI/view?usp=sharing

REgards
- Ashish_Mathur
  Super User
  7 years ago
  Hi,
  
  You may download my PBI file from here.
  
  Hope this helps.
  - Anonymous
    Not applicable
    7 years ago
    Hello Ashish,
    
    Thanks for your response, but it has little bug.
    When i was trying to calculate the count for each month based on category (below screenshot is from the PBXI file"
    
    1. 've a fields under type as "Big-Size" the client counts are not captured from the point where the sum condition is applied since all the bundled clients are BigSize Clients.
    2. the Row level sub total is not captured as showh above.
    3. I wish to check the type level of reporting like Small, Big Size etc.. as per observation, when both the conditions are applied
    
    Regards,
    Varun