Discussions – Power Platform – Dynamics Communities

how to check for ID’s with change in status/category from last 3 months, 6 months, 9 months etc

Power Platform

how to check for ID’s with change in status/category from last 3 months, 6 months, 9 months etc

Posted by DSC Communities on April 14, 2020 at 1:35 pm
- Ape sh
  
  Member
  
  April 14, 2020 at 1:35 PM
  
  Hi Everyone,
  
  I have a quick doubt please if anyone can help?
  
  I am working on a data provided with ID’s, months starting from June’19 to March’20(which will extend till June’20) and category/state(text data) of id. I want to look for ID’s that have not changed their state from last 3 months, last 6 months, last 9 months and so on. Can we do that on powerbi?
  
  looking forward for any help
  
  ——————————
  Ape sh
  60607
  ——————————
- Lutz Bendlin
  
  Member
  
  April 20, 2020 at 8:24 AM
  
  yes, you can do that in a DAX measure using the DATEDIFF() and TODAY() functions.
  
  ——————————
  Lutz
  ——————————
  ——————————————-
DSC Communities replied 5 years, 11 months ago 1 Member · 0 Replies
0 Replies

Sorry, there were no replies found.

The discussion ‘how to check for ID’s with change in status/category from last 3 months, 6 months, 9 months etc’ is closed to new replies.