Forum Discussion

Excellove15's avatar
Excellove15
Iron Contributor
Feb 26, 2024
Solved

Divide the value from month granularity in one table to daily granularity in another table

Hi SergeiBaklan ,   I have a 'Target' table as below: Accruals table as below:   Now i need to split the Target table value column to their corresponding point id and date in Accrual...
BI & Data Analysis
Charting
developer
excel
Excel on mobile
Formulas and Functions
Macros and VBA
office 365
power bi
  • SergeiBaklan's avatar
    SergeiBaklan
    Feb 27, 2024

    Excellove15 

    If in code for the Priority 3 to change

    it is shown

    Not sure about other measures

Excellove15's avatar
Excellove15
Iron Contributor
Feb 27, 2024

Hi SergeiBaklan 

 

Many thanks for the lovely solution sir!:smile:

This solution has worked like a gem and as always you & your quick solution rocks!

you made my day!

 

We need your help in resolving the below issue:

we are trying to dynamically change between profile,direct and target units by referencing them in below measures that point to field parameters

Priority 1 units measures point to Parameter 4 field parameter table
Priority 2 units measures point to Parameter 5 table
Priority 3 units measures point to Parameter 6 table
 
When I drag them in below visual it shows blank for INSE-100:

 

But in data view there is a value for target but not showing in visual:

 

PFA file here https://1drv.ms/u/s!AhUFhM5jR1jqkDlvecc-0Sz09Dr8?e=edTAsd

Please help in resolving this Sir!

 

Thanks in advance!

 

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Feb 27, 2024

Excellove15 

If in code for the Priority 3 to change

it is shown

Not sure about other measures

  • Excellove15's avatar
    Excellove15
    Iron Contributor
    Feb 28, 2024

    Hi SergeiBaklan 

     

    Many thanks for this amazing quick solution Sir!:smile:

    I tried the same in my file, but still i am getting blanks.

    If you don't mind, can you please send me the file so that i can have a look into changes and update my file for other measures as well

    Also, i have marked your solution as the best response!

     

    Thanks in advance!

      • Excellove15's avatar
        Excellove15
        Iron Contributor
        Feb 28, 2024

        Hi SergeiBaklan 

         

        Many thanks Sir!:smile:

        The report is working like a gem! Its a great learning experience Sir! I have closed this query

        As always, please let me know if i can do anything from my end:smile:

Resources